Counting the number of lines by 'Current user'?


I'm looking for a way to count the occurrences of lines with 'Current users' in a grid/report.

I've got a dashboard that displays various lines submitted by multiple users, but uses the current user filter on the report so that the person logged in will only see lines created by them.

What id like to do is create a metric summary which counts how many lines has their name in depending on status (Started, In Progress & Complete).

As far as I'm aware there is no way to use 'Current user' in a formula, so I'm looking for a work around.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!