Referencing rows

johngraham78

johngraham78 ✭✭✭✭

09/07/23 in Formulas and Functions

It is possible to reference a cell in a specific row, via a formula?

For example, I can say [Date]@row to get the date on the current row, or [Date]3 to get the date on row 3.

But I want the '3' to be a formula, which might be something like [Date]@([Reference]@row), where the value of [Reference]@row is 3.

0 ·

Comments

johngraham78 ✭✭✭✭

09/07/23

BTW, Index won't work as this creates a circular reference.

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Index Match
Hello All, =IFERROR((INDEX((COLLECT({Annabelle Pruned}, {Client Name (Pruning)}, [Client Name]@row, {Annabelle Name}, "Annabelle"),1),0) This formula I've used (with the help of the pro desk) elswhere under the same circumstances as the one above: Anabelle pruned is a Boolean, Annabelle Name is a text box. The error is…
Can you help me with a COUNTIFS Formula (Second Criteria)
Trying to count Rows in a sheet that meet 2 criteria. I am not an advanced user, so I am missing something. Can you take a look at this formula and give me some suggestions? =COUNTIFS({Phase-TPN}, "1", [Start SCRA]:[Start SCRA], "Yes")
Can you convert this vlookup to an index match or index collect?
basically, it rest id exists in both SS and on the other SS a field is either checked or unchecked, then result should read Yes. =IFERROR(IF(AND(VLOOKUP([Restaurant ID]@row, {CFA NRO/Remodel Cabling Tracking Range 1}, 1, false) <> 0, VLOOKUP([Restaurant ID]@row, {CFA NRO/Remodel Cabling Tracking Range 1}, 39, false), 0),…