How can i get a row to change color based on partial proof approval (less than 4 but greater than 2)

Manuel V

Jgorsich

ahhh.

Countifs has an implied and() condition - so all of your conditions need to be met, which will never happen since it can't be specifically "Example Name 1" AND "Example Name 2".

Countm() should give you the number of the contacts in the cell. Here is a thread with regard to it:

Counting number of contacts in a cell, "Allow Multiple Contacts" — Smartsheet Community

Jgorsich

Conditional formatting is applied in the order it is listed, with first entries being applied first.

So, set up your conditional formatting like this:

1st condition: if value >=4, give default format

2nd condition: if value >2, give desired format

this way if it is greater than 4 it will stop at the first conditional and that will dictate the row color. If it ISN'T greater than or equal to 4 it will go on to evaluate the second condition and apply your desired color if the value is greater than 2.

Manuel V

Thank you, but what I am referencing is the proofing aspect of Sheets. If I invite 4 people to proof a document and only 2 click on the approve button, how can I create a row to to reflect the two approvals?

Jgorsich

Your approval is being recorded to a sheet, correct? I don't use the approval workflow, going off of this link:

Approval Requests | Smartsheet Learning Center

Is there something that prevents you from doing a countif() on that sheet to count the number of approvals?

You'll likely need to include some screenshots and more reference information to get a more detailed answer.

Manuel V

My approvals from the proofing section of smartsheets is showing up in a column labelled "approved by." As different proofers approve the document the column will auto populate their names in the same cell. I conditional formatting setup to change row color when the proof is approved, however, Smartsheets has a limitation that does not allow the proof to reach final approval until all of the proofers have approved the program. I need to continue to send out these documents daily to the 4 proofers, but only need 2 of them to approve the document to move forward. So, I was trying to setup a workaround utilizing the "approved by" column that would autosum the number of approvals. Problem is I cannot get my countif formula to work. I was using

=COUNTIFS([Approved By]@row, "Example Name 1", [Approved By]@row, "Example Name 2"))

Attached is a screen shot of my reference column. Here only two have approved my document and not all four. In this scenario my workflow could proceed and I am trying to indicate this by a row color change to equal the same color that would autogenerat if all 4 proofers had approved my document.

Manuel V

A follow up screen shot of where that column is generating from:

Jgorsich

ahhh.

Countifs has an implied and() condition - so all of your conditions need to be met, which will never happen since it can't be specifically "Example Name 1" AND "Example Name 2".

Countm() should give you the number of the contacts in the cell. Here is a thread with regard to it:

Counting number of contacts in a cell, "Allow Multiple Contacts" — Smartsheet Community

Manuel V

Amazing!!!!!! Thank you JGorsich!!!

Jgorsich

Glad I could help!