#Invalid Operation - Error

bday2329 ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I have a issue that I just can't figure out. I have 2 identical Smartsheets one was saved as new from the other.

I have the same formula in the same column in the 1 Smartsheet example I get a #INVALID OPERATION (Red Arrow) however in the 2nd Smartsheet example (Blue Arrow) the formula works

 In the attached I have provided example of each sheet with a snap shot of formula's and Columns being used in those formulas

Appreciate any help we are trying to roll this out to depts.

InValid Operation Issue.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!