Welcome!

Help with nesting, please?

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

Find more posts tagged with

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Can I view sheet-level comments on a report?
I have a sheet that already has a "Latest Comment" column, and I can easily pull the row-level comments onto a report using this column. I take this report and use it as a dashboard widget so people can see the latest comments from the sheet all together. However, this sheet will also have sheet-level comments. Is there a…
Why is the sheet name not in the browser tab when in Table view?
The sheet name is in the tab in Grid view, but not Table view, making it difficult to locate a particular sheet when multiple tabs are used. Is this a design oversight?
Which template to choose?
My small civil engineering company is brand new to Smartsheet. I will be overseeing about 70+ projects spread out over 8 engineers in the company. I want to track the status of each project, and add milestones/tasks to each one along the way. Each project also has its own budget. I want to be able to track each project &…