Critical Field Check
Just checking if any update an be applied to this challenge!
I have a Masterdata list and module, that has 200 fields, of which 20 are Primary, 80 are Secondary and 100 are tertiary. When a new product is created, I would like to ensure that ALL the Primary fields are complete and display to the user the status.
Current method would be to write a formula IF ISBLANK(field1) OR ISBLANK(field2) or FIELD3 = 0 OR etc etc etc
Is there a better more robust method for checking fields are complete?