Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
I am trying to count anything that is a past due task, but not counting items that are closed. What is the best formula to use?
My current formula:
=COUNTIF(Due:Due, <TODAY(1))
BUT this is counting all items that are due past TODAY. Any pointers?
=COUNTIFS(Due:Due, <TODAY(1), Status:Status, <>"Complete")
That is assuming your status column is labeled Status and its not a checkbox column. If it is a checkbox column, try
=COUNTIFS(Due:Due, <TODAY(1), Status:Status, 0)
Mike-
It is not supposed to count anything that is closed, lesson learned, or duplicate.
The current formula is:
=COUNTIFS(Due:Due, <TODAY(), Disposition:Disposition, <>"Complete")
This formula is counting those things, however, I need to count anything that is passed due and not closed, lesson learned or duplicate.
Thoughts?
Branden
See also these posts:
https://community.smartsheet.com/discussion/countifs-formula-help-0
https://community.smartsheet.com/discussion/count-anything-passed-due-excluding-certain-criteria
I get this error when I try to edit or go into a form , formName: ajax formAction: fa_getLicensing serverStatus: false serverStatusText: CriticalException errorCode: 48 we upgraded our account recently how do we correct this issue
We are running into issues with our faculty getting sidetracked in the middle of responding to an update request and if they try to use the email link again it gives them a message that says the link has already been used or canceled. Is there a way around this or an idea to help us with this?
Hello everyone, I'm building an automated Above Ceiling Work Permit process for our hospital and have almost everything working. I'm hoping someone can tell me if the final step is possible using native Smartsheet features. My current workflow A contractor scans a QR code and completes a Smartsheet Form. The form creates a…
