Using IF/OR statement in a formula

deb_63_hydracor

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!

Shubham

Hi deb_63_hydracor, 

Please try the below formula- 

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

Image 1

Image 2

Thank you, 

Shubham Umale

Associate - Smartsheet, Ignatiuz Software

DKazatsky2

Hi @deb_63_hydracor ,

You are just missing the @row designator. Try this: =IF(OR([Status10]@row = "Call - Scheduled", [Status11]@row = "Call - Scheduled"), "Complete")

Hope this helps,

Dave

deb_63_hydracor

Hi,

I originally had that in my formula and got an error so removed it. I have added it back into the formula and am still getting an error. I then copied/pasted your formula and still an error.

Shubham

Hi deb_63_hydracor, 

Please try the below formula- 

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

Image 1

Image 2

Thank you, 

Shubham Umale

Associate - Smartsheet, Ignatiuz Software

deb_63_hydracor

Thanks so much!