Renumbering Rows By Checkbox: FormulaMap + Sequence?

1

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!

2

Hey there!

You can use this formula:

image
image1212×518 88.6 KB

I also added a column to your doc!

1 Like
3

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

1 Like
4

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