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.

calculating changes to duration value

Catie Hayes
edited 12/09/19 in Archived 2017 Posts

I need to build a formula to calculate changes to the default duration value within our master timeline template.  


Ideally, I need to the function to notice a change to the default value and calucuate the increase or decrease.  Any suggestions on the approach for this?



  • Jeremy Myers
    Jeremy Myers ✭✭✭✭✭

    Since you have a default value, just write an <if (value of cell not equal to X, then "not default value", " ")) and dump that into a hidden column.  Have conditional formatting look at the results of that column and then format the cell that holds the defualt value as red or something similar.  Cool

This discussion has been closed.