Calculating Yesterday's Accounts Closed
Hi,
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
-
What does this do?
=SUMIFS([ACCOUNTS CLOSED]:[ACCOUNTS CLOSED], [WORK DATE]:[WORK DATE], @cell = TODAY(-1))
If this still throws the same error, double check your column names. Smartsheet hides more than one consecutive space, so if you have (for example) two spaces between Accounts and Closed, it will display as a single space but will not be considered valid if you do not include that second space in your formula.
-
Perfect! Thanks much!!!
-
Answers
-
Hi,
Try the below formula:
=SUMIF([WORK DATE]:[WORK DATE], [WORK DATE]@row = TODAY() - 1, [ACCOUNTS CLOSED]:[ACCOUNTS CLOSED])
Thank you!
-
Hi Paul,
It still comes back as Unparseable.
-
What does this do?
=SUMIFS([ACCOUNTS CLOSED]:[ACCOUNTS CLOSED], [WORK DATE]:[WORK DATE], @cell = TODAY(-1))
If this still throws the same error, double check your column names. Smartsheet hides more than one consecutive space, so if you have (for example) two spaces between Accounts and Closed, it will display as a single space but will not be considered valid if you do not include that second space in your formula.
-
Perfect! Thanks much!!!
-
Help Article Resources
Categories
Check out the Formula Handbook template!
