I CAN´T SET MULTIPLE COLUMNS FORMULA

Silvina

=IF(AND([Fecha de analisis]@row = ""; [Fecha de analisis]@row = ""; "FALTA COMPLETAR"; "COMPLETA"))

tHE MESSAGE IS:

THERE IS AN ERROR HERE AND I DONT KNOW HOW RESOLVE IT

Silvina

sORRY, THIS IS THE FORMULA:

=IF(AND([Fecha de analisis]@row = ""; [Fecha de envio de informes]@row = ""; "FALTA COMPLETAR"; "COMPLETA"))

Josh Reed

Hi Silvina,

It is difficult to determine exactly what you are attempting, but just looking at the formula I'll take a shot at helping! Try this instead:

=IF(AND([Fecha de analisis]@row = "", [Fecha de envio de informes]@row = ""), "FALTA COMPLETAR", "COMPLETA")

You were very close to the correct syntax!

Important to note: this formula will now check to see if BOTH of those columns are blank for that row, and if BOTH are blank it will say "Falta Completar", but if EITHER or BOTH are not blank it will say "Completa".

Andrée Starå

https://community.smartsheet.com/discussion/comment/392097#Comment_392097

Hi,

I hope you're well and safe!

Try something like this.

=IF(AND([Fecha de analisis]@row = ""; [Fecha de envio de informes]@row = ""); "FALTA COMPLETAR"; "COMPLETA")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

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

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

Silvina

Hi Andree,

didn´t work:

I need this: if one column it´s empty, the message still be "FALTA COMPLETAR"

Andrée Starå

https://community.smartsheet.com/discussion/comment/392132#Comment_392132

Try this.

=IF(OR([Fecha de analisis]@row = ""; [Fecha de envio de informes]@row = ""); "FALTA COMPLETAR"; "COMPLETA")

Did that work?

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

Silvina

=IF(OR([Fecha de analisis]@row = ""; [Fecha de envio de informes]@row = ""); "FALTA COMPLETAR"; "COMPLETA")

THIS WORKS!!!!!

tHANKS

Silvina

Andrée Starå

https://community.smartsheet.com/discussion/comment/392135#Comment_392135

Excellent!

Happy to help!

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