Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Count specific list items in child
I have a list of reports being sent to specific users as seen here:
- User 1 xxxxxx
-- Report 1 Monday
-- Report 2 Thursday
-- Report 3 Daily
In the "xxxxxxx" cell, I'd like something like this: M:2 T:0 W:0 T:2 F:0
to let me know at a glance how many reports someone is getting on daily basis. I can't spread the sheet out to use check boxes, it all needs to be in 1 cell. Is there a way to add just each instance of Monday and Daily, and use a concatenate formula to put it together as seen?