Aging formulas in Smartsheet

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,

Find more posts tagged with

Formulas

Comments

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())

PeterG

or try this

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

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)

Sign in to join the conversation!

Quick Links

Trending discussions

Circular Reference with formula
i am not good with writing formulas within a sheet. I asked the AI tool in the sheet to help me write a formula and I am getting a Circular reference back. I'm trying to have it write the following formula for me. If the column "Tracking #" is not blank, change Column "Deployment Phase" to "Shipped" I have tried adding in…
How to delay the execution of a workflow whose trigger occurred much earlier?
I have a workflow that detects a row(date) that is changing its Fiscal Week Finish Date and send this row to other Sheet. Long story short: I collect delayed tasks in separate file & I tag reasons for delay for these tasks. It happens that plan are analyzed 2-3 hours and dates are being changed several times. I would like…
INDEX/COLLECT??
Having trouble with an INDEX/COLLECT/CONTAINS formula. I have two sheets, my source and my destination; the source sheet has a column I want to collect into the destination. -Tool ID, is in both sheets and the target of the INDEX/MATCH, the source sheet might have this listed 6 or 7 times -Purpose of Device, there are…