Validations/checks before changing the status of a row
First of all thanks in advance for support.
I have a question, which i think is basic.... but i haven't find the way to solve it.
I have a sheet with a status column, then i have 2 columns for KPI values: Status, KPI1, KPI2, start date, end date, etc....
I want to "not allow" to complete the task if the columns with the KPI are not filled. I need the system to prevent the user to change the status to "complete" if the 2 columns are not filled.
I need the user to control the status cell, so, i can not put an "automatic" status formula calculation.
I dont see any automation to change the value of a row, i can move rows, i can send emails but i can not do something like IF ((KPI1 is null) and (KPI2 is null)) then status = in progress, triggered when the status changes to complete.