Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So I have this sheet that does daily reports, but whenever I open the sheet, the date is set back to
and I have this setting applied to it:
How can I make it so that when I open the sheet, it will automatically show the latest date (which is always the previous day, so today it would show 7/21/2022)
Click the field's search option (from Selections or a filter), and use something along the lines of:
=batchdate2=date(Max(all batchdate2))
You may need to modify this a bit depending on the formatting and such - it may not need the date() part, or you may need to format it - but you should be able to get it to work so that only the max date is displayed. Once it is, hit "Enter" on your keyboard to select this date. After it is selected in this way, create a bookmark, and make that bookmark your default bookmark for this document. That will always set the batchdate2 field to max(all batchdate2).
How do you make a default bookmark?
Right click on it to set it as default