Hi,
I need to calculate the sum across a number of columns that will change every month (mon columns are set from January to December for each year). This would easily be done in Excel via an OFFSET function and I can't find what the equivalent would be in Smartsheet.
What I am trying to get at is this:
=SUM(OFFSET([Current Month]@row,0,0,1,[Jan'21 LE / Act]@row))
Where Current Month column shows the number of the month we are in
and
Jan'21 LE/Act column is the first column I am summing data from for 2021.
Can someone advise how I could get to my result?
Many thanks,
Julie