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
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?

Tags:
· Share on FacebookShare on Twitter

Comments

  • 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

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories