Sorry if this has already been answered - can...

[abg_appsheet]

Sorry if this has already been answered - can i create a scheduled report that sends me notification of an event that starts in 30 days or less ? I have insurances that expire continuously through the year and a column that tells me the expiry date. I have tried the expression TODAY()=insurance expiry -30 it still doesn’t send me a the report

[Suvrutt_Gurjar]

@abg_appsheet, You could create a slice on the said table with filter condition as [Expiry Date]=Today()+30

You could schedule a daily report based on this slice.

[abg_appsheet]

@Suvrutt_Gurjar just tried and when i run the test it brings back all of the rows rather than the expected . currently only testing with 25 rows of data

[Suvrutt_Gurjar]

@abg_appsheet,

Could you please check the 'test" panel of the slice filter condition , it needs to show “Y” only for all rows with [Expiry Date] of 22nd

November, if you are checking the condition today that is 23rd October.

[Phil]

@abg_appsheet

I think you want something like

AND([Expiry Date] >= TODAY(),[Expiry Date] <= TODAY()+30)

[abg_appsheet]

Many thanks for your help , done it following one of the sample apps and adding a calculated column in the spreadsheet and then creating a slice based on that value