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!