What am I doing wrong in this formula?

Applecor2

Where I am hung up is if the scheduled date is BLANK I want it to return the text PENDING SCHEDULE

=IF([Completed Date]@row <> "", "Completed", IF([Scheduled Date]@row <> "", "Scheduled", IF([scheduled date]@row "", "Pending Schedule")

ker9

Hi @Applecor2

Looks like you are missing an equal sign after the last "@row" - bolded below

=IF([Completed Date]@row <> "", "Completed", IF([Scheduled Date]@row <> "", "Scheduled", IF([scheduled date]@row = "", "Pending Schedule")

That jumped out at me but it's possible something else is wrong - let us know if that fixes it.

Hope this helps!

ker9

Hi @Applecor2

Looks like you are missing an equal sign after the last "@row" - bolded below

=IF([Completed Date]@row <> "", "Completed", IF([Scheduled Date]@row <> "", "Scheduled", IF([scheduled date]@row = "", "Pending Schedule")

That jumped out at me but it's possible something else is wrong - let us know if that fixes it.

Hope this helps!

Applecor2

That did it thank you so much....So easy!! :)