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!!!
-
Happy to help. 👍️
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!!!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!