Permit formulas in columns with the "Restrict" value toggle enabled

ritzbitz00

I have columns that are set to take certain types of data, and they contain formulas that fill the cells with values permissible within that data type. For instance, there's a field where a formula fills in one of several options based on a cell reference, or the user can manually select one of the options from a dropdown menu. I have another field where cells reference another to return dates, but a user can overwrite that date with a different one if necessary.

If i turn on the toggle to Restrict values to the field type, I get error messages that there are values in the cells that aren't permitted: formulas in cells, even when they return the appropriate data type, are not considered a value match for the column and are removed. This is prevents the use of data validation and value restricting in fields that contain formulas, and introduces data hygiene issues that should be resolved

I would like for this to be fixed. Excel and other spreadsheet software are able to recognize formula results as a value type, but Smartsheet blocks formulas from working in fiels with value-type restrictions.