Run a formula based on another cell input

CMI

Hello,

I am attempting to return formula based on the input of a separate cell. The objective is to calculate number of days since a date, based on a qualifier in another cell.

For instance -

Column 2 has a yes/no drop-down option.

Column 3 has a date

Column 4 would use an argument where if column 2 is "yes" then column 4 would return days since the date listed in Column 3.

I have been using =NETDAYS([Original Date]@row, TODAY()) to calculate the date, however I would like to use a condition that only triggers the formula based on a "yes" entry in Column 2. This will allow for some clean dashboarding elsewhere with limited manual input.

Thanks!

Andrée Starå

Hi @CMI

I hope you're well and safe!

Try something like this.

=IF([Yes/No Column]@row = "Yes", NETDAYS([Original Date]@row, TODAY()), "")

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @CMI

I hope you're well and safe!

Try something like this.

=IF([Yes/No Column]@row = "Yes", NETDAYS([Original Date]@row, TODAY()), "")

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

CMI

Thank you @Andrée Starå that did work!

Andrée Starå

@CMI

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!