Auto Fill with Dates if certain category is selected

Obullock · 08/04/22

I am trying to figure out how to have certain cells auto fill with a generated date if a certain category is selected. Example: If "communication" is selected, I need a cell to auto fill with a date that is a week earlier than the "due date" column. Is there a way to do this? Thank you!

Paul Newcome · 08/04/22

Try this:

=IF([Column Name]@row = "Communication", [Due Date]@row - 7)

Paul Newcome · 08/04/22

Try this:

=IF([Column Name]@row = "Communication", [Due Date]@row - 7)

Obullock · 08/04/22

That is exactly what I needed! Thank you so much!

Paul Newcome · 08/05/22

Happy to help. 👍️

Auto Fill with Dates if certain category is selected

Best Answer

Answers

Categories