IF #INVALID OPERATION

Rosario Barros

Hi I am using this formula to define Health of the project with symbols in the summary sheet

=IF([Gap vs SMS]15 >= 14, "Yes", IF(14 > [Gap vs SMS]15 >= 0, "Hold", IF([Gap vs SMS]15 < 0, "No")))

Formula works ok, but when I copy to other sheets, a few of them appear with invalid operation and I can´t find what could be different.

any ideas?

Thanks!

Rosario

Andrée Starå

Hi @Rosario Barros

I hope you're well and safe!

Make sure the column names are correct, and then try something like this instead.

=IF([Gap vs SMS]@row >= 14, "Yes", IF(14 > [Gap vs SMS]@row >= 0, "Hold", IF([Gap vs SMS]@row < 0, "No")))

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Rosario Barros

Hi! Thanks for your reply. That doesnt seem to be issue. Right now, i realize that the formula only worked when the result was under yes...for the rest is showing me invalid operation..

is the formula wrong?