Calculating Yesterday's Accounts Closed

Jay Moss

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)

Paul Newcome

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.

Jay Moss

Perfect! Thanks much!!!

Paul Newcome

Happy to help. 👍️

Shanky Paul

Hi,

Try the below formula:

=SUMIF([WORK DATE]:[WORK DATE], [WORK DATE]@row = TODAY() - 1, [ACCOUNTS CLOSED]:[ACCOUNTS CLOSED])

Thank you!

Jay Moss

Hi Paul,

It still comes back as Unparseable.

Paul Newcome

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.

Jay Moss

Perfect! Thanks much!!!

Paul Newcome

Happy to help. 👍️