Days since Submission if not complete

Paula Cosentino

Hello all. I love that I can come to you for help. Eternally grateful!

I tried to find this in other threads but could not get them to work for me.

I'd like to count the number of calendar days since the date in "Date Submitted" if the checkbox in "Review Complete" has not been checked. Thank you very much.

Paul McGuinness

Hi @Paula Cosentino

No trouble that's why we are all here to learn and help each other.

This should do the trick for you

=if([Review complete]@row=False,Today()-[Date submitted]@row,"")

Hope that helps

Thanks

Paul

Paul McGuinness

Hi @Paula Cosentino

No trouble that's why we are all here to learn and help each other.

This should do the trick for you

=if([Review complete]@row=False,Today()-[Date submitted]@row,"")

Hope that helps

Thanks

Paul

Paula Cosentino

Paul, thank you very much for taking the time to answer. That works! I was trying to use 0 to indicate Review Complete was not checked. Thanks again!!!! Paula