I have a status column in a SharePoint list. I need to write validation to make sure the statuses go in order. The correct order for all entries should be ” not started” -> ” In Work” -> “Complete”. I also want to make it so that if the list item is a “Material Site transfer” to “XYZ city” it will allow you to choose ” in transit” so the order would be ” not started” -> ” In Work” -> ” in transit” ->”Complete” but only if the Request type = material site transfer and To location = XYZ city. Any help would be appreciated, Im not savvy with coding.

​I have a status column in a SharePoint list. I need to write validation to make sure the statuses go in order. The correct order for all entries should be ” not started” -> ” In Work” -> “Complete”. I also want to make it so that if the list item is a “Material Site transfer” to “XYZ city” it will allow you to choose ” in transit” so the order would be ” not started” -> ” In Work” -> ” in transit” ->”Complete” but only if the Request type = material site transfer and To location = XYZ city. Any help would be appreciated, Im not savvy with coding.  Read More

​