Hello,

Is there a way to show a list of people who have not yet responded? In other words, how can I create a column formula to show the names of people who are still showing "Submitted" or "Pending?"

Thank you, wizards!

Hi @Andrée Starå !

Trying to simplify my project in case it's applicable to anyone else :)

I am working on a sheet to track contract approvals. There will be several approvers on each row, and I want to be able to quickly see who still needs to approve each. I have a column set up for each approver that records a date that they either approved or declined the approval request, as well as an approval column that shows the status (Submitted, Approved, or Declined).

I'm just wondering how I can fill in the "Pending Approvers" column to show any contacts listed in the "Approvers" line whose status is still listed as "Submitted" in the approval columns. Apologies if I'm not explaining it very well!

So sorry for all the additional posts, but I was able to sort it out! It's a bit convoluted, but my solution is this:

1) Set an automation to clear the "Pending Approvers" column - triggered every morning.

2) Set an automation for EACH approver to assign them to the "Pending Approvers" column - triggered every morning, an hour after the first automation, under the conditions that they are A) listed in the "Approvers" column and B) their approval status is NOT Approved or Declined.

3) Set an automation for EACH approver to assign them to the "Approved By" column, triggered by the change in their approval status to either Approved or Declined. I added a condition here that they are listed in the "Approvers" column, but that's probably unnecessary.

This only works if each approver has their own Approval Status column, but in my case, it's totally worth the effort. Thank you for letting me work this out by writing it all out on this forum. Maybe it will help someone in the future! I'm also still very open to hear other thoughts and options :) Screenshots of my automations below: