I want to use a Flag column to mark high-priority tasks and calculate a reduced lead time.
In a Due Date column I use a formula to add 7 days to the Received Date. I want to change the formula so that it adds only 5 days IF the flag is checked. I can't seem to find out how to reference the value of the flag cell, though. Is there a way to do this?