Help with nesting, please?

CarolinaMGB

Hello, I am a beginner... Would anybody help me to nest this formulas? They work independently but when I try to integrate them, I cannot make them work. Maybe is not the right formula for what I want to do. I have a symbol column that should apper Red("No") or Green ("Yes"), conditioned by different combinatios of four other columns: starting date (fecha comienzo), finishing date (fecha fin), check for started (Iniciado), check for not completed (Finalizado).

=IF(AND(Iniciado1 = 0; [Fecha comienzo]1 < TODAY()); "No")

=IF(AND(Finalizado1 = 0; [Fecha fin]1 < TODAY()); "No")

=IF(AND(Iniciado1 = 1; [Fecha fin]1 > TODAY()); “Sí” )

=IF(AND(Iniciado1 = 1; [Fecha fin]1 < TODAY()); “No” )

=IF(AND(Iniciado1 = 1; Finalizado1 = 1); "Sí")

 

Thank you very much!!

Carolina

Andrée Starå

Hi Carolina,

It's important that the nested IF's come in the correct order because it will stop when it's true.

Which formula are you trying that isn't working?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Andrée Starå

Glad we got it working!

Best,

Andrée