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

Count value in columns
Hello, I have a question about creating a specific formula. What I want to know is: how many columns has a value? From the columns Dgn_Funct, Dgn_DEV, Dgn_Int, Dgn_ BI. What is the best way to set up this formula? I tried several one but not found the best. The result will be shown in the blue column, this will be 0, 1, 2,…
Formular Workday Count
Hello, I've formula use Workday to count Due date = Start Date @row cell + option days. fx Image below: Start Date is 04/24/25, then added 11 days = Resulted 05/09/25 as Due date. Now, out of curiosity added days manually = Resulted 05/08/25 as Due date. Some folks prefer manual counting😓. And I need to able to understand…
Logic formula to return a value on another sheet based on two search criteria
I am trying to develop a formula that will return a request ID # to an invoicing sheet. The source sheet includes the request ID # and two columns with the criteria I want to be met (Lot Charge Fee, Ready to Invoice). I want the request ID # to only show up on the invoicing sheet if the following criteria is met: Lot…