Grabbing text from a cell based on the "current" or recent date

Hello All,

I am trying to figure out how to grab a specific calc from a sheet that I will use as a KPI on a dashboard via the metric widget. I need to create a formula that will go through and find the calculation that is the most current and place it in the cell I will use for the metric. The idea is that as I populate the sheet it will automatically change the metric data based on the date and update the dashboard.

In the sheet below I want the most current % (Spent/Projection) to be pulled into the (Current) Spent/Projected column.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!