Hey Everyone!
I’m trying to create a table will generate a new, sequential invoice number for every record that has a certain field checked. Right now, I have the formula IF(Awarded = 1,2000+ {Field 32}, BLANK()) so that if I check the box for “awarded”, it takes the record number and adds it to 2000 which is the lowest invoice. The issue with this is that it generates records that don’t have the checked field and just doesn’t display them, so if I have three jobs in a row and the first and last have the field checked, they appear as 2001 and 2003 because there is an unchecked record in between the two that the formula counts. Is there a way I can change this so that it generates the next sequential number while also ignoring unchecked fields?
I’ve been trying to find formula I could use that would scan the field and then add 1 to that most recent or the largest number already used in that field? I would love to have something that goes off of the field and not the number of the record. Thanks!
