How do I set a list column to its default value if it's not on the "New Item" form

Question

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.

Answer 1

Yes/No fields need to be treated as boolean. So you need to use a choice field if you want to require a choice.

With DB Mods Required as a radio button with Yes/No as options, try this validation formula: =IF(AND([Status]="Migrate",ISBLANK([DB Mods Required]),false,true). This says that if Status is Migrate, but DB Mod Required has not been filled out, validation fails.