Is there a formula that can pull data based on row # & column name?
For example, I know that on row 732 (specifically that row) in the Primary column I will need information to appear in another cell. Linking things manually is not an option given the volume of rows, so I need a formula.
Any way this can be done?
Also, the information in row 732 can be moved. So in the future the data today in row 732 may be in row 563.
I'm not entirely optimistic about this because I am aware that there is no function in Smartsheet that can ID row numbers. But I thought I'd give this a try and ask.
Thanks in advance.
Help Article Resources
Check out the Formula Handbook template!