If OR and SUM formula
Options
Hi,
I created this formula but I'm not sure why I'm getting the error message "INVALID DATA TYPE"
=IF(OR(Name@row = "AB", "CD"), [Number1]@row, SUM([Number2]@row:[Number5]@row))
Tags:
Best Answer

You are close, your syntax is just off by a bit.
=IF(OR(Name@row = "AB", Name@row = "CD"), [Number1]@row, SUM([Number2]@row:[Number5]@row))
Answers

You are close, your syntax is just off by a bit.
=IF(OR(Name@row = "AB", Name@row = "CD"), [Number1]@row, SUM([Number2]@row:[Number5]@row))

@Carson Penticuff It worked!! Thank you so much!! I truly appreciate your quick and very helpful response!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!