I'm trying to uses nested ifs to change what a choice column displays but I'm not sure if this can be done or if I'm doing it properly. What I'm trying to have accrue is once the next review date passes the current date, the reviewed column switches to "No" using the below statement.
=IF(AND([Next Review Date]>=[Date of this Review],Reviewed?="Yes",IF[Current date]>=[Next Review Date],Reviewed?="No"))
I'm relatively new at using calculated columns and I still don't quite understand the syntax.
Columns:
- Reviewed?: Drop-Down Choice Column| "Yes","No"
- Last Reviewed date: Calculated Column| =[Date of this Review]
- Date of this Review: Date and time Column| Default Today's Date
- Next Review date: Calculated Column| =[Date of this Review]+[Review Frequency]
Review Frequency: Number column
Status: Calculated Column| =IF(AND([Next Review Date]>=[Date of this Review],Reviewed?="Yes"),"1 - Green","2 - Red")