Formula guidance


Hi guys!

I am trying to help fix a sheet that was built by someone else, and that person is no longer working for the company. They have a Dashboard that pulls data from a metrics sheet, that pulls data from a main data sheet. It looks to me like the sheet was moved or something, as it appears to have disconnected from the formula. I'm trying to redo the formula now, but I'm having a hard time understanding the end of his formula. I've copied it below - does anyone know what the $120 might mean?

The data this is pulling over is a total # of loans, per each individual Loan Officer, on a monthly basis.

=COUNTIFS({RefLO}, Names@row, {Month}, [Oct 2023]$120)

Thanks in advance!!



  • KPH
    KPH ✭✭✭✭✭✭

    120 is the row number. So the count is including rows where the value in the Month range on the other sheet matches the value in column Oct 2023, row 120.

    The $ symbol is used to fix the row number, so if you drag this formula to another row it still refers to row 120. Without the $, if you dragged this from row 1 to row 2, for example, the reference would change from row 120 to row 121.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!