Forum Discussion
Solved
A complicated IF
I have three columns
- Confidence levels (High, Medium, Low)
- Training Date
- Reassessment Date
- I would like this column to automatically show the date for the following
- High: add 90 days to training date
- Medium: add 60 days to training date
- Low: add 30 days to the training date
- I would like this column to automatically show the date for the following
12 Replies
- Or is there a way to make it so every time I make a new row, the formula is there automatically?
If use Excel Tables formulas will be repeated automatically for every new row of the table.
SergeiBaklan Can I include this in a data validation? If so how?
I didn't catch about data validation, what is the purpose. Is that for Reassessment Date which entered manually?
