Sheet Update Display on Dashboard

Options

Hi Smartsheet Community!

I've reviewed and tried a couple different formulas for my question, but none have seemed to work. I am trying to display on a dashboard the last time a form was submitted and entered into a grid/sheet. I can manually enter the update into the dashboard, but I would like to automate it to pick up the last entry submitted. I only need the date, not the time (which is automated as well on the sheet). Here's what I'm looking to capture:

The formulas I have tried are:


=MAX (resulted in "0")

=MAX({RP3 UAT Issues Intake Grid - Test Master Range 3})


and =INDEX + MAX(COLLECT...) (Resulted in "unparseable"), where Range 5 = Date/Time Received column selection and Range 6 = Row 7 selection (last row displayed).

=INDEX({RP3 UAT Issues Intake Grid - Test Master Range 5}:{RP3 UAT Issues Intake Grid - Test Master Range 5}, MAX(COLLECT({RP3 UAT Issues Intake Grid - Test Master Range 6}:{RP3 UAT Issues Intake Grid - Test Master Range 6}, {RP3 UAT Issues Intake Grid - Test Master Range 5}:{RP3 UAT Issues Intake Grid - Test Master Range 5}, <>""))


Clearly, I'm not doing something right. ;) Appreciate any assistance!

April

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!