Count by date modified
I would like a COUNT of Number of Task Items (these are multi-select) of the number of "lodging" for the past 7 days but I want to go by the date modified.
What am I doing wrong?
My formula isn't working:
=COUNTM(COLLECT(Task:Task, Modifiedby:Modified by, @cell >= TODAY(-7), Modifiedby:Modifiedby, @cell <= TODAY(), HAS(Task:Task, "Lodging", @cell)))
I keep getting Unperseable
Help Article Resources
Check out the Formula Handbook template!