Compare users in fields

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • In Progress
I need to compare Field A and Field B below.  Field A is a multiple user select and B is a multiple choice.  The users in Field A have been selected to approve a document.  They must all complete before the approval is complete.  I have created a checkbox to do this.
Contains([Quality Approval],(Part(UserListToNames([Quality Team]),1,";"))&"] Approved") and
Contains([Quality Approval],(Part(UserListToNames([Quality Team]),2,";"))&"] Approved") and etc.

My issue is I want to know which user has selected on the dropdown "Approved" or "Rejected".  So if a 10 users in Field A are required and only 9 have approved- which user am I waiting on.  I am putting a lot of documents through our system and would like a way to see this quickly.


I now have this formula:

var Text QTA = Part(UserListToNames([Quality Team]), 1, ";"); 
var Text QTB = Part(UserListToNames([Quality Team]), 2, ";");
var Text QTC = Part(UserListToNames([Quality Team]), 3, ";");
var Text QTD = Part(UserListToNames([Quality Team]), 4, ";");

If (not Contains([Quality Approval], $QTA & "] Approved"), $QTA) &
If (not Contains([Quality Approval], $QTB & "] Approved"), $QTB) &
If (not Contains([Quality Approval], $QTC & "] Approved"), $QTC) &
If (not Contains([Quality Approval], $QTD & "] Approved"), $QTD) &

Which works great.  The problem is they are allowed to reject and say what they need to change.  I want to know who all has not responded - chosen "approved" or "Rejected".

I also would like a coma or semicolon between each name.  
Photo of Sarah Bunten

Sarah Bunten

  • 664 Points 500 badge 2x thumb

Posted 10 months ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 28,304 Points 20k badge 2x thumb
Maybe this:
var Text QTA = Part(UserListToNames([Quality Team]), 1, ";"); 
var Text QTB = Part(UserListToNames([Quality Team]), 2, ";");
var Text QTC = Part(UserListToNames([Quality Team]), 3, ";");
var Text QTD = Part(UserListToNames([Quality Team]), 4, ";");
If (not Contains([Quality Approval], $QTA & "] Approved")
    and
    not Contains([Quality Approval], $QTA & "] Rejected")
    , $QTA) &
If (not Contains([Quality Approval], $QTB & "] Approved")
    and
    not Contains([Quality Approval], $QTB & "] Rejected")
    , $QTB) &
If (not Contains([Quality Approval], $QTC & "] Approved")
    and
    not Contains([Quality Approval], $QTC & "] Rejected")
    , $QTC) &
If (not Contains([Quality Approval], $QTD & "] Approved")
    and
    not Contains([Quality Approval], $QTD & "] Rejected")
    , $QTD)

But at some point writing formula this long becomes ridiculous.
(Edited)
Photo of Sarah Bunten

Sarah Bunten

  • 664 Points 500 badge 2x thumb
The ";" does not work.  Any ideas on this?  I want to separate somehow.