I am creating a project tracking list using Sharepoint-online.
I'd like the Status column to default to "Requested", so, in the column definition, I've set that as the default value from the list of available Status I've defined (Choice field, not a Lookup).
When I created a new "NewItem" form, I did not include the "Status" column. When I attempt to save the form, my validation fires telling me that some data is missing.
Unfortunately, the validation is supposed to trigger when the Status column = "Migrate", not "Requested"
. The validation formula on the Status
column is: =AND(Status="Migrate",[DB Mods Required]<>"")
([DB Mods]
is a Yes/No
column). This indicates to me that the Status column is not getting the correct default value from my NewItem form.
If I use the default NewItem form, I see that the proper default value (Requested) is set, and I can save the item without the validation triggering.