If the true sequence, without gaps, is needed you will need to create a numeric field.
You will want to export/import to make the update as needed.
>Create a report with two columns, [Record ID#] and your [Formula RFI # Field]
>Sort by the Formula field.
>Export to Excel
>Re-number from 1 (or whatever starting point you want)
>Import the new list with the Record ID# and the new sequence to a new numeric field.
Now you will know your 'max' number and max record ID#. You can then adjust your formula to automatically pick up where you left off.
Then you can combine the formula and the numeric field that you just imported to.
So it will either use the imported value, or use the formula to make a new value.
If(IsNull([Imported Sequence]), [Record ID#]+1000, [Imported Sequence])
Then you wont have to update any of your other reports/formulas.
