Help with nesting, please?

CarolinaMGB
edited 12/09/19 in Smartsheet Basics

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

Comments