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

Find more posts tagged with

Comments

Lisa

I modified the formula as follows -

=IF(COMP@row = "X", 0, IF([DUE DATE]@row >= TODAY(), 0, [DUE DATE]@row - TODAY()))

now if it's 30 days in the past, it will say -30 and if it's not due for 30 days it will say 0

I'd like it to be a positive 30 if it's overdue by 30 days.

Lisa

Solved my own issue, I guess coffee hadn't kicked in yet -

=IF(COMP@row = "X", 0, TODAY() - [DUE DATE]@row)

Jeremy Davis

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

Sign in to join the conversation!

Quick Links

Trending discussions

Project Comment/ Update
Hi, Is there a feature in Smartsheet that allows us to add comments daily, weekly, or monthly, and filter them later to review what happened on the project during a specific week or month? or create report ? Thanks JCG
Advise on Workgroups and access for Groups
I have Workspaces that have sheets containing sensitive information. The Workspaces have Individual access to a few people. With in the Workspace, I created Dashboards, with Dynamic Views. Each is set with specific Groups to access specific information. The users in the groups can not see or access the Dashboards, unless I…
Document filtered by form responses
I've created a Smartsheets form. When someone submits the form, I want them to automatically be emailed a document that has resources and links, but the document is filtered to only show the content that corresponds with what they selected in the form. Is something like this possible? What types of documents or automations…