if no date selected the max date data should be displayed

[Sameer9585]

Hi,

I have created an app for the tickets but the end user output is max date data should be displayed below I will show the snapshot and I need the output like it. I am having output as 1 st one I need the output like 2nd one.

I will also provide the app i created and the dataset that I used in it Sheet 11 is the dataset

[Sameer9585]

Data set is below in it Sheet 11 is the data

[sunny_talwar · Accepted solution]

Change your dimensions to this

ID

=if(Start_Date<=Max(TOTAL Date),ID)

 Status

=if(End_Date<=Max(TOTAL Date),'Close','Open')

[Sameer9585]

Thanks a lot