Why are $ used in some formulas?

Beth Fantozzi 1
βββββ
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
-
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
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!