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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!