Sudden Invalid Operation Error

jprovateare

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.

jprovateare

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

jprovateare

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