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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!