number of days past due - change to positive number
Hello -
I have this formula - =IF(COMP@row = "X", 0, [DUE DATE]@row - TODAY()) in a column entitled "Aging".
If a user marks an item complete with an X, then nothing appears in the aging column. If the due date is in the past by thirty days, the formula produces a -30. If the due date is in the future by 30 days, the formula produces 30.
I'd like the formula to produce nothing if the due date hasn't past and a positive number, not a negative in the Aging Column so if it's thirty days past due, the column will have 30, not -30.
If anyone can help, thanks in advance!
Lisa
Comments
-
Solved my own issue, I guess coffee hadn't kicked in yet -
=IF(COMP@row = "X", 0, TODAY() - [DUE DATE]@row)
-
Hey Lisa,
Glad you found a solution. I was going to suggest wrapping your formula with the ABS() function to return the Absolute Value (30). Yours looks much cleaner.
- Jeremy
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives