Formula to count number of Days and not counting Status

Peppey

Hi everyone. I hope everyone is doing well. I was wondering if I could please get some help. I have a tracker named eAPP, I am trying to count the number of Days since Assigned for 0 to -12 days but exclude in the count if the Current Status is "Completed". I have tried so many formulas, but nothing is working. Thanks. Brian

Paul McGuinness

Hi @Peppey

Apologies updated formula

If(Contains("Action Complete",[Current Status]@row),"",Today()-[Days since assigned]@row)

Thanks

Paul

Peppey

Perfect thank you so much

Paul McGuinness

Hi @Peppey

Without seeing sheet specifics I would use something like this:

If(Status@row = "Completed","",Today()-Assigned@row)

Assumption that status column contains where the completed is updated and the assigned column is where the date would be and that column is formatted as a date.

Hope that helps

Thanks

Paul

Scott Peters

Hello @Peppey - I guessed at your exact column names:

=IF([Current Status]@row = "Complete", "", TODAY() - [Assigned Date]@row)

I hope that is helpful!

Peppey

Thank you both sir! I apologize I should have been more specific. There is an autocalculate column int he tracker and need the count the autocalculate days showing the numbers. For example, in the autocalculate column in the tracker there are number such as 0, -12, -28, etc. I need to count the number of 0 to -12 from this column (named Days since assigned).

Scott Peters

Could you please post a snip of that column? It would help to understand the data a little better

Peppey

Yes of course. See below

Paul McGuinness

Hi @Peppey

Apologies updated formula

If(Contains("Action Complete",[Current Status]@row),"",Today()-[Days since assigned]@row)

Thanks

Paul

Peppey

Perfect thank you so much