Sign in to join the conversation:
The current formula is:
=COUNTIFS(Due:Due, <TODAY(), Disposition:Disposition, <>"Complete")
I need to count anything that is passed due and not closed, lesson learned or duplicate. I am utilizing a drop down box, too.
Thoughts?
Branden
Almost like you said
=COUNTIFS(Due:Due, @cell < TODAY(), Disposition:Disposition, NOT(OR(@cell = "Complete", @cell = "Lesson Learned", @cell = "Duplicate")))
Craig
This appears to be a duplicate of this post:
https://community.smartsheet.com/discussion/count-anything-passed-due-excluding-certain-criteria
The formula has been corrupted and all we have are 0's. They are in our PO Expenses but not syncing with the job.
I am trying build a helper column which will be ticked if the value under the column PROP_CD has a duplicate. I am currently using this formula =IF(COUNTIFS([PROP_CD]:[PROP_CD], [PROP_CD]@row) > 1, 1, 0), but all the cells return error "NO MATCH" Would appreciate any help or insight…
Hi all, I'm building out a month-end checklist for a department and they want to be reminded on Day 1 of every month to start their tasks and on Day 10 to complete their tasks. I was able to create a simple workflow that on Day 1 and Day 10 of every month, it sends them a reminder, however, they have asked if day 1 or 10…
