Nested formula to present the most recent KPI value from a row
I am trying to pull the most recent month's value to the 'Current Month Data' cell to use for Dashboard Widgets that will only present the Goal and Current Month Data. There are 30+ KPI values that need to have the latest month's value, and I'm stumped on how to build the nested formula to make it work. The same formula will work for every KPI (row).
Below you'll see the month columns, and the Current Month Date column in the screenshot. I thought I'd just use the modified column with a between dates formula. For example: the value in the Current month data column for January is displayed if the modified column has a date between Feb 1 and Feb 28, then the next imbedded piece is the same for Feb, Mar, April, etc. Any ideas would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!