Using IF/OR statement in a formula

Options

Hi,

I'm trying to have the status on Row 9 update to 'Complete' if either Row 10 or 11 have a status of 'Call - Scheduled' but I am getting an error.

=IF(OR([Status10]="Call - Scheduled", [Status11]="Call - Scheduled"), "Complete")


Thanks!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!