I am building a dispatch app for my company and am trying to edit my “Completed” slice to show any row with a status of complete AND a collection date within the past 30 days. I can’t for the life of me figure out the expression I need to input and this is the last piece I need. Any help is appreciated!
Have you already tried something like this?
AND([Status]="Complete",[Date]>=TODAY()-30)
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |