Auto Fill with Dates if certain category is selected

Obullock

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

Try this:

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

Paul Newcome

Try this:

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

Obullock

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

Paul Newcome

Happy to help. 👍️