Slice

[Betti]

Hello Everyone,

I want to create a slice with status=“current” and follow the expiration dates and show what expires within 30 days.
So, for example: [Status]=“Current” and [Technical exam]<=TODAY()+30,
How can I do this to make the slice work?

Thank you for the help,

[Suvrutt_Gurjar]

Please use AND() function in the slice row filter expression something like

AND( [Status]=“Current” , [Technical exam]<=TODAY()+30)

AND() - AppSheet Help

[Betti]

Thank you. And if I want to add 2 more columns at once? Is this still the principle?

[Suvrutt_Gurjar]

If you mean in the AND() condition , then yes, one can add as many columns as one wants.

[Betti]

If I write with only one column, it works. If with two, then no. What did I do wrong?

[Suvrutt_Gurjar]

Maybe the table does not have any records that satisfy the row filter condition. Please use the Test button under the expression to evaluate the expression results. The test results give clues about where the expression or test data needs to be corrected.

[Betti]

Solved it.

[Suvrutt_Gurjar]

Great, thank you for the update.