Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
I would like a way to determine if a cell contains a literal value or a formula calculated value.
For example: On a project sheet we have multiple date fields for different actions to complete on the same item. By default we use formulas to generate estimates for all the date columns. Some users may enter an actual date to override the calculated delivery date. We would like to be able to apply conditional formatting so that it would be visually clear which dates are calculated as opposed to overridden, something like IsFormula([Date1]20) would be perfect.