Renumbering Rows By Checkbox: FormulaMap + Sequence?

Hi all, apologies for this question, as I believe it may have already been answered. I’ve searched and searched, and can’t find what I’m looking for.

I want to renumber rows after a user chooses to include them via a checkbox. I need a formula to calculate the values for “Renumber” that I’ve entered manually.

I thought I could sequence from 1 to the number of checked boxes, then run a FormulaMap to assign the numbers, but I’m getting caught up in either currentvalue, Nth, or some other trickery.

Thanks for the help!

Hey there!

You can use this formula:

I also added a column to your doc!

1 Like

Incredible, thanks so much Scott! You’re a hero :supervillain:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.