I have a SharePoint list with several choice, date, text and yes/no fields. I want to make some fields conditional on another field containing a certain word.
So for example, I have a field called 'Status' (a choice column) that has the choices: In progress, Completed, Finalised.
I have a second field (a date column) called 'End date' and I want that field to be required only when the Status is Finalised.
Is that possible?