Looking for a formula to look down a column to entries that are the same and looking at a status
I am various reports that will be generated under 1 intake challenge ID as these reports will go to different sets of approvers depending on location. Is there are formula that will go down this column and check to see that everything under a unique Challenge ID has been Approved by All?
I need a column for this to link back to my intake sheet so I can filer anything that has been Approved or Rejected out of my Data Connector that uses Alteryx to garb intake requests and do comparisons to create the reports that need the approval tracking.
Once a specific Challenge ID created in the Smartsheet with the Intake Form has been completed and everything is either "Report Approved By All Approvers" or "Rejected" I would want that NTIA Challenge ID Approval Status to Update so I can pull in that status by the Challenge ID in from the intake for my filter.
Help Article Resources
Check out the Formula Handbook template!