Like in write back (dyna) tables in web spreadsheets it is necessary to define allowed entry values. This means e.g. from a dimension subset or a manual/dynamically defined list. Instead of formulas an expression would make sense.
data validation...
data validation.png
Open full size
ADMIN RESPONSE
May 23, 2025
Thank you for your great idea. While we cannot commit to a specific target version, we will consider adding it to our future internal backlog.