sheet summary error

The formulas in sheet summary change based on what column I sort by.. very unhelpful. (Even if I add $ to my formula....) Anyone else run into this bug?

Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    Hi @Sofia Fernandez

    Paul is correct! The reference is in regards to that specific cell, no matter where the cell is moved in the sheet. An absolute reference locks the formula so you can move and drag-fill the formula up and down without the reference auto-changing as you shift the placement of the formula... however if you move the row with the referenced cell to a different location, the formula's row number will shift to follow that specific piece of data, as Paul outlined.

    That's a good question in regards to documentation. There is a Help Center article on creating references in formulas (see here), which identifies that the row numbers are to select a cell (versus locking to a row/placement in the sheet) and reference the data inside that cell.

    However there is no description/documentation of what will happen to that row number when you Sort a sheet that I can see. I'll provide feedback on that article to see if we can clarify this; if you wouldn't mind also providing feedback (through the "Was this article helpful?" question on the very bottom right) I would appreciate it!

    Thanks,

    Genevieve

    Need more information? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!