List Item Validation With The Content Type Field

Question

Is it possible to use a validation formula with the content type field?

Something along the lines of:

=IF([Content Type]="Project",Status="Closed",IF([Date Closed]=TODAY(),TRUE,FALSE),TRUE)

My list has more than one content type and the Date Closed field is not used in all of them.

List settings --> Validation settings

Michael Han · Accepted Answer · 2020-08-12 09:18:58Z

1

No, it's impossible to use the content type field in list validation.

As a workaround, you could create another column and copy cotent type to it.

answered Aug 12, 2020 at 9:18

Michael Han

5,1811 gold badge7 silver badges12 bronze badges

If I create a field to mirror the Content Type field, the above code example would work? I only want the validation to check on some of the Content Types on my list. Not all of the Content Types in my list have Date Closed associated with them.
– Taco_Buffet
Aug 12, 2020 at 13:14

Add a comment |

1 Answer 1