Aging formulas in Smartsheet

alonzo.edwards
alonzo.edwards ✭
edited 12/09/19 in Formulas and Functions

Hi,

I have a column titled aging and its the [created date]-[Today()]. The problem is that there is no trigger when the line item is completed/canceled, as a result it shows that that item is still currently aging in fact it has been completed/canceled. What I would like to do is build if possible and If statement that if the status is complete then default the aging cell to "0". Any suggestions on how to do this?

Thanks, 

Tags:
· Share on FacebookShare on Twitter

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    See if this one works? I'm not totally sure on all the details of your columns... but check out this one based on column23. You'll need to replace the status column title with your own

     =IF(OR([status column]23 = "completed", [status column]23 = "canceled"), 0, [created date]23 - Today())

    · Share on FacebookShare on Twitter
  • PeterG
    PeterG ✭

    or try this

    =IF(Complete1 = 1, 0, (Created1 - TODAY()))

    · Share on FacebookShare on Twitter
  • Tristan Hair
    Tristan Hair ✭

    I had wanted to know how old something is, unless it was done... and if it was done what the duration had been.

    =IF([Resolution Date]1 = "", TODAY() - [Initiated Date]1, [Resolution Date]1 - [Initiated Date]1)

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!