I am using a formula based on a status column to generate dates for specific tasks. For example, if a task is deemed to be Short, the formula will take the original date and add 1 to get the due date on the task. Is there a way to take that date in Line 1 and copy/push that to another date field in line 2 to run the formula against that? All of the statuses for each task are already determined, so in theory, when I would put the first date in, it would generate the dates for all of the other tasks from that.
The board is based on a workflow where a customer requests training for a new product or service, and our Learning & Development team create the training and accompanying documents in a certain timeframe.
Hopefully this makes sense. Thanks for the help!