Calculating Yesterday's Accounts Closed



I'm trying to design a formula that calculates the total number of accounts completed by my staff. The formula that I'm using comes back as "Unparseable". Please take a look and let me know what I'm doing wrong. Thank you. =sumif(WORK DATE:WORK DATE, WORK DATE @row= TODAY(-1), ACCOUNTS CLOSED: ACCOUNTS CLOSED)

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!