Hi, i've added a field to a custom form that uses a formula based on another cell in form. basically is the field is empty return 'Pass' if not then 'Fail' however the field only seems to update after I edit then save a record. is there a way I can get the formula to run on all existing records?

@Steve If your custom field's Store Value setting is set to false, that will do the trick. However, keep in mind that has consequences in regards to how that field can then ultimately be used. Otherwise, if you need Store Value to be true, you will need to run a mass update or CSV import to set it.

Thanks Oliver, that makes sense now

Also, until the record is saved the first time it won't work. You could use a workflow to set values