You’re offline. This is a read only version of the page.
I have 2 columns in my Google Sheet that requires a formula to be added.
The first formula, which is quite simple is =ROW()-1, if you just type that it adds the ' in front so therefore doesn't function as a formula, so I tried concatenate and it stops at the = sign even if you use "" to indicate text.
The other is more complicated to use the above field and add it in a true concatenate field, once again it adds the ' in front which breaks the formula and just makes it a string of text.
Can someone please help this has really stumped me. Solving the simple one should solve the other one for me too.
Thank you for any assistance
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (