This feels like a dumb question.
I'm trying to get a count of total "To Do" items in the entire Status column from the Team SCRUM: Communications sheet. This function is working fine without the cross-sheet reference, but nothing I've tried is working to correct the issue.
The formula is as follows:
=COUNTIF({Team SCRUM: Communications STATUS Column}Status:Status, "To do")
Any pointers?