Trying to figure out how to write a formula in Google Sheets that will automatically calculate a deadline for me based on priority and an established date.
I have 3 columns: Date (A), Priority (B), and Deadline (C).
Here's what I'm trying to accomplish:
- If Priority (B) equals 1, then return A.
- If Priority (B) equals 2, then return A+3.
- If Priority (B) equals 3, then return A+7.
How in the hell do I write this as a single formula that goes into each row under column C (Deadline)?