I want to do an IF statement and if its true then I want another column to be set.. I am using list validation on a Sharepoint list:
=IF([Master vs Copy])="Master",([Duplicate Rationale])="None"), TRUE)
So the column called 'Duplicate Rationale' is a choice column and I want to set it to value None (which is in the columns).
Any help would be brilliant as I don't know how to set a column in list validation.