I have a "Submit" yes/no column once users are ready to finalize the form. Upon "Submit" I want to require a Vendor2ProposedPrice column, which is a SharePoint currency column. Adding this rule to the Vendor2ProposedPrice column works when the column is blank/empty:
and(Submit==true, isNullOrEmpty({Self}))
The problem is the currency column is blank only when the form is new, or being filled out for the first time. Once the form is saved as a draft the currency column populates a default of 0, even though I have no default set in the SP column. So the formula works if users submit as draft but once they go back in the formula doesn't work because the field is no longer "empty". I tried the formula below but it doesn't work because it doesn't work only on submit, as it forces a price for drafts as well. Which I don't want it to do. I want it to force a number higher than 0 upon "Submit" only.
and(Submit==true, isNullOrEmpty({Self})) || equals(Submit==true, Vendor2ProposedPrice=="0")
