I am trying to update a column value IF the Date presented in another column has been breached. I will then need to format the row the has breached this date in Red.
The columns are:
Date Requested: Requested delivery date Formatted as a Date
Outside SLA: Yes/No Toggle
Logic behind this:
If Date Requested is today or greater, set outside SLA to Yes. Highlight Row Red.
If Date Requested is less than today, leave Outside SLA at its default Value NO
Is this at all possible, i feel like i may be treating SharePoint too much like Excel which i know is incorrect. Any advice on this would be appreciated. Thanks for your time