Best Of

Hi@JJWW

I hope you're well and safe!

Dynamic View is an excellent solution, but if it would work depends on who and how many different submitters and different domains there can be.

Another great solution is the following from@Cleversheet.

Would any of those options work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå| Workflow Consultant / CEO @WORK BOLD

✅了我的帖子(s)帮助或回答你的问题吗tion or solve your problem? Please support the Community bymarking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

{Done}, @cell=1

is looking for rows where the box IS checked. We want to look for rows where the box IS NOT checked.

{Done}, @cell<>1

Hi@WinaHath

I hope you're well and safe!

I'd recommend an INDEX/MATCH combination. Here's the structure.

=INDEX({ColumnWithTheValueYouWantToShow}, MATCH([email protected],{ColumnWithTheValueToMatchAgainsTheCell}, 0))

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå| Workflow Consultant / CEO @WORK BOLD

✅了我的帖子(s)帮助或回答你的问题吗tion or solve your problem? Please support the Community bymarking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

@Miew

In your data sheet do as follows:

1. Add column "LINE-ID" : Auto Number Column (unless you have one already, if yes use the column name in step 2)
2. Add column "ROW#" : Column Formula: =MATCH([LINE-ID]@row, [LINE-ID]:[LINE-ID], 0)
3. Make sure agents, advisors, and coordinators columns are next to each other in your sheet.

Then your formula to count active through all 3 columns is the below (you will need to add the 2 cross sheet references bolded:

=COUNTIFS({ROW#}; HAS(INDEX({Agent-Coordinators cross sheet reference}; @cell); [Employee's Name]@row); {Status}; "Active")

Hi Orlando, try this. E.g.

=COUNTIFS({MH-Work Prioritization Log Range 1}, "Completed- Prioritized", {Completed Date Range}, >=DATE(2023, 1, 1), {Completed Date Range}, <=DATE(2023, 3, 31))

--Anson