So I have a column titled status which has three values which = Line Manager, Director, Approved and Issued. This will be hidden and I need it to automatically be assigned according to answers in certain columns beforehand.
I need it to assign ‘Line Manager’ however,
if column ‘TYPE’ = ‘Other’ AND column ‘Price’ is greater than £2500 then I need it to assign ‘Director’
I also need it to automatically assign ‘Director’ if column ‘TYPE’ = ‘Plant’, ‘PPE’, ‘Sub Contractor’
So, there are a couple of potential results which will assign the Status.
Thanks in advance.