After counting a table, I want to use the result to start a record number.
So if the count is 1000, the first number needs to be 1001 then 1002 and so on.
I uploaded a sample of what I am trying to do.
I tired using what I have in the sample. Also tried the multi-row formula but that did not work either.
Thanks
Solved! Go to Solution.
That worked great. Thank you
Hi @Trip ,
I twisted a little bit your formula tool by making the sum of the first record ID and your count to get your new record ID.
See attached workflow.
EDIT : I didn't get what you needed. Now that I do I modified your workflow accordingly.
User | Count |
---|---|
19 | |
15 | |
13 | |
9 | |
8 |