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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!