Tracking responses system
I feel this is probably a very low level type of request that I'm just not thinking through the correct way. I've done some decent uses of SmartSheet and have some automated workflows I've built, etc., so I feel like this is a pretty ignorant question but I'm going to ask it anyway, 😀.
I routinely will query 6-12 department leaders asking for the answer to a specific topic. Not infrequently I have an inconsistent response rate which then requires me to track who I heard from and who I didn't.
I'd like to develop a sheet/system where I can track each request and whether each person responded and be able to do some automated 'pinging' of non responsive people. Also to have some visual accountability for the group to see "oh, look Johnny has replied to each item and Sarah hasn't replied to anything."
I figure each Row could be a query/question being asked with a column for detail. I then thought do I need to have 6-12 columns for each person's name? I assume using a Contact Field and then only that person would be used in that column? It seems perhaps not the most efficient though.
Thanks in advance for wisdom!