I'm a newbee to SP. I have a list that has following columns in my custom list in Sharepoint Online.
PrjStatus Name Start Date End Date SummaryLink and so on...
PrjStatus is a choice column with values (INTAKE, ACTIVE, HOLD, COMPLETE, DUPLICATE)
If the user selects 'COMPLETE' for this field, then when he tries to save, it has to check if the 'End Date' & 'SummaryLink' columns has values. If they have values, then the row gets saved. Otherwise a custom message should come up and it shouldn't let the user save.
I tried various things by setting formulas in column validtion on the PrjStatus column but none of them are working. Pls advice.
I'm using this formula, but it isn't working giving the following error
=IF([Project Status]="COMPLETE",AND(NOT(ISBLANK([SummaryLink])),NOT(ISBLANK([End Date]))),TRUE)
The formula cannot refer to another column. Check the formula for spelling mistakes or update the formula to reference only this column