Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I wrote sheet name in my new sheet , But i want create a variable max date and when reload the data that will update. And max date concatenate with sheet name.
Ex: Sales analysis (11-12-2018) [ i have to show these in my new sheet option]
Hi ,
use Below expression in Title Expression
='Sales analysis ' & '(' & vToday & ')'
Create the sheet name as an expression something like this:
='Sales Analysis (' & Date(Max(YourDateField), 'DD-MM-YYYY') & ')'