Forum Discussion
SHAREPOINT COLUMN VALIDATION --- NOT ALLOW "COMPLETADO" STATUS IF ANOTHER COLUMN IS BLANK
I have a list in sharepoint, I want the "TaskStatus" column not to allow me to put the value "COMPLETADO" if another column (the column is called "Description_Agent") is blank.
These are the columns in the list
I've tried changing the "Description_Agent" column to a single line of text as well and it doesn't work.
These are all the tests I have done and they all give me error.
----------------
=IF(OR([TaskStatus]="EN PROCESO",[TaskStatus]="COMPLETADO"),IF(ISBLANK([Description_Agent]), false, true), true)
=OR(ISBLANK([Description_Agent]),AND([TaskStatus]="COMPLETADO"))
=IF(AND(ISBLANK([Description_Agent]),AND([TaskStatus]="COMPLETADO")),false,true)
=IF(AND(ISBLANK([Description_Agent]),([TaskStatus]="COMPLETADO")),false,true)
=IF([TaskStatus] = "COMPLETADO", IF(ISBLANK([Description_Agent]), false, true), true)
=IF(AND([TaskStatus]='COMPLETADO',(NOT(ISBLANK([Description_Agent])))
=IF(AND([TaskStatus]='COMPLETADO',(AND(ISBLANK([Description_Agent])))
=AND([TaskStatus]="COMPLETADO",(NOT(ISBLANK([Description_Agent]))))
=IF(ISBLANK([Description_Agent]))=TRUE,IF([TaskStatus]=”COMPLETADO”,FALSE,TRUE),TRUE)
--------------------------------
I would appreciate your help
Best regards
3 Replies
- If you can't use PowerApps, maybe you can try JSON formatting. It works with multiple line of text fields. You would have to work out the logic to meet your needs, but maybe hide the TaskStatus field while it equals "In Process" and the Description_Agent field is empty. Then they won't have the option to mark it Complete until the Description if filled out.
- It will be easier to customize the form with Power Apps to enforce those kind of rules.
I have taken it into account, but I prefer to put this validation from sharepoint, it would be more complete.
thanks u
