Unable to create absolute reference to a cell in smartsheet.
I am trying to create an absolute reference to the cell Test1 for example, where Test is the column and 1 is the row. In order, to make the absolute reference I add $ in front of the column name and in front of the row number, $Test$1. However, whenever I, for example, insert a row above that cell or sort the values, the absolute reference value changes to the new position of that cell, however I want the reference to that cell to stay as $Test$1.
Some additional contextual details. I am trying to do this in the summary fields, to have a summary that will simply store the most updated row so I can then create a metric in the dashboard that will be updated with this summary fields.
Help Article Resources
Check out the Formula Handbook template!