I am trying to create an IF-OR statement however I'm left with #INCORRECT ARGUMENT SET. This formula works on Excel however I have issues with smart sheets. 

=IF(OR([Mi-Tech Status]4856 = "Canceled", [Mi-Tech Status]4856 = "Transferred", [Mi-Tech Status]4856 = "Cancel", [Mi-Tech Status]4856, IF(ISNUMBER([Splice & Test Actual]4856), "Spliced & Tested", IF(ISNUMBER([Cable Placed Actual]4856), "Cable Placed", IF(ISNUMBER([Construction Start Actual]4856), "Construction Underway", [Mi-Tech Status]4856)))))

Any idea what I'm missing?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!