Hi all,
Probably a very simple one to solve, but I can't crack it.
I have the following columns:
- Mitigation Date
- Close Date
- Status
- Overdue?
I want to create an IF function that combines the following statements:
If 'Mitigation Date' is before Today() and 'Close Date' is blank, show "Yes", otherwise show "No"
If 'Mitigation Date' is before 'Close Date', show "Yes", otherwise show "No"
Thanks all,
Bookmarks