isFormula function.

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.

Find more posts tagged with

Formulas

Conditional Formatting

Comments

Travis

Hi James, there isn’t a function that will identify if a cell contains a formula but you could turn on highlight changes which would apply formatting to any cell that was edited within a given timeframe. You could turn this on then check the date column for cells that have been modified. You can then view the history of these cells including what changes were made, who made them, and when by right clicking on the cell and selecting View History.

Roland Horwood

Hi,

isformula would be a great addition. I have several sheets and workflows that have calculated dates in cells that are then overwritten manually when "real" dates are available. The ability to conditionally format these to highlight when dates have been entered would be very useful to users.

Regards - Roland

Jeff Pream

I second the request for detecting a formula in such a way that we can detect if it has been overwritten. My particular example is such that I use "=SUM(CHILDREN())" to total our project schedules and since SmartSheet does not have a way to total the complete hierarchy of parent/children I need a visual way to know if one of the "=SUM(CHILDREN())" has been over written.