Why are $ used in some formulas?

Can someone please explain the purpose of the "$" in this formula?

=IFERROR(DATEONLY($[End Date]$198) + "", "")

Is there a benefit to having those in there? I know the formula will run just fine without them, that's why I am asking. Thanks in advance!

Answers

  • DKazatsky2
    DKazatsky2 ✭✭✭✭✭

    Hi @Beth Fantozzi 1,

    The use of the "$" anchors the formula so if you copy/past or drag it over, it will still refer to that exact cell. Without it, the columns/row would change based on the new location. In other words, if you dragged this down, and the "$" was not used, the formula would resolve to =IFERROR(DATEONLY([End Date]199) + "", ""). NOTE the row number change.

    Hope this helps,

    Thanks.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!