Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Yesterday's Completed Task Formula
I am looking for a way to capture the number of taks that were completed yesterday. I started by using a report however yesterday or last working day were not an option. I tried using in the last days - and used 1 however when yesterday is a weekend is skews the data. I then tried using a COUNTIFS formula but I run into the same issue when yesterday is a Sunday.
=COUNTIFS([RHB TO AUDITOR]:[RHB TO AUDITOR], (TODAY() - 1))
When I try adding NETWORKDAY I get an error. what is wrong with my formula?
=COUNTIFS([RHB TO AUDITOR]:[RHB TO AUDITOR], NETWORKDAYS(TODAY() - 1))
I want to count if that field was yesterday.
Thanks for the help!
Comments
-
Hi Marie,
What do you want to happen if yesterday was a weekend - go back to the previous Friday? Let me know and I'll work on it!
-
Yes. Thats why I was thinking NETWORKDAY - let me know! thanks.
-
This is a start - this will count everything that was completed yesterday and not a weekend:
=COUNTIF([RHB TO AUDITOR]:[RHB TO AUDITOR], @cell = (TODAY() - 1)) - COUNTIFS([RHB TO AUDITOR]:[RHB TO AUDITOR], OR(IFERROR(WEEKDAY(@cell), 0) = 1, IFERROR(WEEKDAY(@cell), 0) = 7), [RHB TO AUDITOR]:[RHB TO AUDITOR], @cell = (TODAY() - 1))
