Output of date formula not detected as date type in a grid

JLMingo

Hi,

We have a grid where users type in dates. Sometimes, dates are hard coded values, but sometimes it is convenient using a formula to calculate the value. For instance, you might want to calculate the value as another column + 30 days.

The problem I see is, we have those columns configured as dates, with the "restrict values to dates only" option activated. This ensures users are not typing incorrect values, which is pretty normal when dealing with dates. The problem comes when somebody wants to introduce a formula as described before. The output in the cell is "INVALID COLUMN VALUE". I think Smartsheet detects the output of a formula as Text/Number, even if the output is actually a date.

Any way to solve this issue?

Paul Newcome

It must be entered into a date type column. The other date must also be in a date type column and contain an actual date. It must also be in the order of [Date Column] + number of days. If you try to use something along the lines of 30 + [Date Column], it will error out.

If you have confirmed all of the above, some screenshots and some examples of formulas being used would be helpful.