Last value in a range (Return)?
I have a column (set of cells) which I'm using to attain Sum and Count figures from a series / row of numeric information. In addition I need to return the last entry made in the series. For example: There are 52 weeks in the year and we are collating information weekly and entering these figures into the corresponding cells...A summary column is used to Sum, Avg and count these cells up - what's missing is the last entered field i.e. week 8 being my last entered field (at present).
Is there a formula or easy way to do this (help would be greatly appreciated)?
Comments
-
Hello,
You'll want to add either a date modified or date created column to your sheet. More on these columns can be found in the help center: https://help.smartsheet.com/articles/1964567-system-columns
You can then create a MAX formula that returns the latest value. The MAX formula has to be placed in a different column, since you can't edit system date columns directly.
More info on MAX here: https://help.smartsheet.com/function/max
