3 Replies Latest reply on Sep 5, 2018 9:59 AM by James Bills

    How to get corresponding string value for a Min Date

    James Bills

      Hello Community,

       

      I have data where I want to select the minimum date which is later than today's date, then take the corresponding string value for that date.

      I want to put this info into a tooltip so each car has its eta, and destination. (see example data where desired data is highlighted red)

      I have put a ETA >= today's date filter on the page, then put Min date into the tooltip. This has worked

      I can't seem to get the correct string value that corresponds to the specific date

      (The rest of the sheet has different data from a different source)

       

       

      Would be grateful for any help,

      Thanks

       

      James