Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Upon opening of the app, I want all sheets to show only the data for the current fiscal year.
Any suggestion is greatly appreciated. Thanks!
add your <year_field> as a filter and search =<year_field> = max(<year_field>) and hit enter (selects max year dynamically). save as bookmark, right click the bookmark and "set as default". That's the best way to do this in my opinion. User can change the year selection right from the selection bar if they want.
add your <year_field> as a filter and search =<year_field> = max(<year_field>) and hit enter (selects max year dynamically). save as bookmark, right click the bookmark and "set as default". That's the best way to do this in my opinion. User can change the year selection right from the selection bar if they want.