Help with formula that wont run


Hello everyone!

This simple formula is driving me nuts

=SUMIF([Is this before today?]@row, "Yes", ([Actual]@row-[Actual Cumul]1), "",)

This keeps returning an #UNPARSEABLE error

I'm trying to get an answer for simple sum

If the current column (is this before today) is yes. Then subtract the "actual" value from the previous days "Actual Cumul" value.

What I'm after, is a value for the sum. Or if the date is in the future I want an empty cell hence the "" for the result if its not a yes in the "is this before today" column.

Please can someone help!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!