Hi, Currently, whenever an entry is added through a form on a app, I insert this formula with Zapier (it’s in dutch): =IFS(B42=“ContentA”; IFS(ISLEEG(E42);TEKST.SAMENVOEGEN(D42;" “;F42);NIET(ISLEEG(E42));TEKST.SAMENVOEGEN(D42;” “;E42;” ";F42)); B42=“ContentB”; C42;B42=“ContentC”; C42) However, I …

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.

Your solution works, and I have the correct formula with row numbers in Glide. However, when added to Google Sheets, it is added with an ’ at the start, which causes it to not transform to a formula but just plain text. How do I fix this?

Check the column type in Glide and make sure it’s a number type. But, what is the formula for? The solution I gave you doesn’t require any formulas.

The formula I posted at the start of this topic is the formula I want to add to a field—every time a new entry is created. Thanks to your comment, I was able to get the formula with the correct row numbers. However, I now need to ensure that the formula is parsed correctly in Google Sheets.

Yes, you’re right, I thought the formula would be more straightforward, but it ended up being more work, so I replaced the whole formula with some columns, which now does precisely the same. Thanks for your help!

Get row number in a field

Ask for Help

Darren_Murphy December 3, 2021, 4:01pm 2

If your end goal is to get an auto-incrementing number, here is a method you can use that is pure Glide.

Topic		Replies	Views
Creating index UID Ask for Help	2	416	August 18, 2020
Adding a new row in google sheet leaves a blank row cell in number column Ask for Help	7	568	June 19, 2023
Inputted Goggle Formula not working? Ask for Help	19	318	April 18, 2023
Formula create on new ron insert google shgeets Ask for Help	2	229	March 23, 2023
Increment + GSheets Ask for Help	11	688	November 22, 2022

Get row number in a field

Related topics