Sudden Invalid Operation Error
I can see from our audit trail that, on 9/18/24, some of the formulas in our summary sheet suddenly switched from their calculated answers to #INVALIDOPERATION but I can't figure out why. Here's an example:
=SUMIF(Status:Status, "Open", [Extended Cost]:[Extended Cost])
This formula seems correct to me… for all rows where "Open" is in the status column, sum the values in the column "Extended Cost".
This formula was working just fine before and I can't see where anyone changed anything. Anyone have any suggestions? This has happened for several formulas in the summary sheet for this smartsheet.
Best Answer

Figured it out! There was an entry in the unit cost (used to calculate extended cost) that was text instead of number.
Answers

Figured it out! There was an entry in the unit cost (used to calculate extended cost) that was text instead of number.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!