How do i set up a conditional format, when i want more than one person in the assigned to column

image.png

I have each assigned to person with conditional format with a color to let them know what they are assigned to work, but what if i need two or more associates to work that particular assignment, how do i set up conditional formatting for that, or would that be a formula?

Best Answer

  • Kelly P.
    Kelly P. ✭✭✭✭✭
    Answer ✓

    @Genesia

    I would use conditional formatting. The rules for individual people should be in the form "If Assigned To is equal to 'Curtis Coleman' then apply this format to the entire row." It's important to use "is equal to" rather than "contains." Then add a final rule (at the bottom of the list of rules): "If Assigned To is not blank then apply this format to the entire row."

    With this structure and wording for the rules, rows with a single person assigned will get their individual color and those with two or more people will get the color you assign in the last rule.

    Hope this helps!

Answers

  • Kelly P.
    Kelly P. ✭✭✭✭✭
    Answer ✓

    @Genesia

    I would use conditional formatting. The rules for individual people should be in the form "If Assigned To is equal to 'Curtis Coleman' then apply this format to the entire row." It's important to use "is equal to" rather than "contains." Then add a final rule (at the bottom of the list of rules): "If Assigned To is not blank then apply this format to the entire row."

    With this structure and wording for the rules, rows with a single person assigned will get their individual color and those with two or more people will get the color you assign in the last rule.

    Hope this helps!

  • Thank you so much that was so helpful and it worked.

  • Kelly P.
    Kelly P. ✭✭✭✭✭
Hi DnG,<\/p>

Click on Share button of your Dashboard and fill in emails that you want to give access.<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":108571,"type":"question","name":"Update request for one task assigned to multiple people","excerpt":"I want to have multiple people assigned to a task. When I send out the update request to the contacts assigned to that task, both get the form and when one updates data, the other then has to override the data when they respond, not being able to capture both user's response makes it hard to ensure we are getting all…","snippet":"I want to have multiple people assigned to a task. When I send out the update request to the contacts assigned to that task, both get the form and when one updates data, the other…","categoryID":321,"dateInserted":"2023-08-05T02:52:46+00:00","dateUpdated":null,"dateLastComment":"2023-08-05T05:27:49+00:00","insertUserID":164622,"insertUser":{"userID":164622,"name":"vbhagwat","title":"Smartsheet User","url":"https:\/\/community.smartsheet.com\/profile\/vbhagwat","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtfpRmkKUCirzorCUC6UH0zkBJMpc5D1ZnONzBhLmAV1=s96-c","dateLastActive":"2023-08-07T09:37:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":137040,"lastUser":{"userID":137040,"name":"Gia Thinh","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Gia%20Thinh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pXMt6Y5Kqjs!ZHDtmZp0Yms!Dwma-t47hzh","dateLastActive":"2023-08-07T09:48:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":48,"score":null,"hot":3382417835,"url":"https:\/\/community.smartsheet.com\/discussion\/108571\/update-request-for-one-task-assigned-to-multiple-people","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108571\/update-request-for-one-task-assigned-to-multiple-people","format":"Rich","lastPost":{"discussionID":108571,"commentID":389072,"name":"Re: Update request for one task assigned to multiple people","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/389072#Comment_389072","dateInserted":"2023-08-05T05:27:49+00:00","insertUserID":137040,"insertUser":{"userID":137040,"name":"Gia Thinh","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Gia%20Thinh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pXMt6Y5Kqjs!ZHDtmZp0Yms!Dwma-t47hzh","dateLastActive":"2023-08-07T09:48:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-07T09:41:05+00:00","dateAnswered":"2023-08-05T05:27:49+00:00","acceptedAnswers":[{"commentID":389072,"body":"

Hi vbhagwat,<\/p>

To capture both user's response to ensure we are getting all department perspectives, some ideas you can consider:<\/p>