Run a formula based on another cell input



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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!