Hello Smartsheet Community!
I have a formula that is acting up on one of our sheets. We use a budget sheet that is standardized across multiple Business Units and one of the sheets is currently throwing an #INVALIDVALUE error with the below formula.
=IF([PO or CC]@row = "Purchase Order", SUMIF([Salesforce Case#]:[Salesforce Case#], [Salesforce Case#]@row, [Purchase Amt]:[Purchase Amt]) + SUMIF([Salesforce Case#]:[Salesforce Case#], [Salesforce Case#]@row, [Inv Paid Amt]:[Inv Paid Amt]), "")
This formula works totally fine in other sheets and fundamentally I cannot see why this is acting up. Any suggestions are welcomed as I am grasping at straws here.
Below is a screenshot of a test entry I am working off of where you can see all content is present. It should simply subtract the Inv paid amount column from the Purchase amount and queries off of the same Salesforce Case number.
