The $ Formula
A consultant I worked with was tasked with building a graph showing our portfolio growth over time. The graph needed to be a 12-month trailing horizontal axis which uses the (already recorded) dates for when any new project is triggered for provisioning. On the vertical axis, we wanted to track the sum of the project sizes that were triggered a given that month.
In the dedicated metrics sheet for this chart (see image below to make sense of what's going on)
The consultant derived the year from the Today column and subtracted the manually-entered number of days above it (column 1). Here is the formula that was used in the cell [12 months]2:
=YEAR($Today@row - [12 Months]1)
He also used it to determine the Month values [12 months]3:
=MONTH($Today@row - 360)
My question is... What does the $ do to the Today function? I cannot find any information on this anywhere on smartsheets' formula glossary or in any online discussion. I don't want to break the metrics sheet but the data is currently not summing correctly and noticed that this could be a problem down the line, but I am not sure.
Help Article Resources
Check out the Formula Handbook template!