Get row number in a field

I think the whole point was to build the resulting column value in glide. Not build the formula for google to do the work to get that resulting value. If you build all of the logic in glide, then you will not have any of the lag you were worried about when waiting for glide and google to resync.