Unwanted Default gray background of the dropdown selections

Alejandrommm
Alejandrommm ✭
edited 11/11/21 inSmartsheet Basics

Hello, I am trying to change the backgound color of the Dropdown selections that appear in the cells to white.

Is this possible? is there any CSS formatting i can give to the background of the dropdown selections?

Screenshot 2021-11-11 at 22.40.59.png

I would like that gray background gone please

Tags:
· Share on Facebook Share on Twitter

Best Answers

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    Hi@Alejandrommm

    I hope you're well and safe!

    Unfortunately, as far as I know, it's not possible now, but it's an excellent idea!

    Please submit an Enhancement Request when you have a moment.

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    ✅Did my post(s) help or answer your question or solve your problem? Please support the Community bymarking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter
  • Alejandrommm
    Alejandrommm ✭
    edited 11/11/21

    thank you a lotAndrée✌️, i will do.

    Another question then please; Do you know then how i can hide that dropdown selection in the cell? like so it can look like there is nothing there?.

    · Share on Facebook Share on Twitter
  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    @Alejandrommm

    You're more than welcome!

    The best way I've found to make it less visible is to color the background in the same color.

    Would that help?

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter
  • Alejandrommm
    Alejandrommm ✭

    Thank you Andree i have tried that, but it is still great to know that that is the only solution available [:

    · Share on Facebook Share on Twitter
  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    @Alejandrommm

    Happy to help!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter
  • Shauna Brotz
    Shauna Brotz ✭✭✭
    edited 01/05/23

    Hello. Somehow, however I don't know what I did, I was able to remove the gray background on my dropdown items in one of my Smartsheets, so there has to be a way.

    image.png

    如你所见,我下拉包括在办公室,卧室rk from Home, Travel, and PTO all having a different color. However, the gray background does NOT show up.

    A question I have and hopefully one of you can answer regarding dropdown menus is...in the dropdown column I have chosen the option of multiple names, but as you have stated that we cannot remove the gray background. I am wanting to put a conditional format together that when one or more names are chosen under the column I want only that cell to change color to gray. When there is nothing in the cell, I want the cell color to stay soft yellow. Everything I have tried in the conditional formatting is NOT working...HELP?!?

    · Share on Facebook Share on Twitter
  • Genevieve P.
    Genevieve P. Employee Admin

    Hi@Shauna Brotz

    The grey background behind text appears if you are using a multi-select dropdown list, as it shows the separation between dropdown options. However if you change the column type to besingle-select, then the cell text and background colour will be the default colour.

    Can you post a screen capture of how you have the conditional formatting rule set up? It sounds like there may be a conflicting rule or a criteria we're missing to get the background colour how you'd like.

    Screenshot 2023-01-06 at 17.25.38.png


    · Share on Facebook Share on Twitter

Categories

What type of plan are you on? Certain plan types require that a system admin give you permission to access group management.<\/p>


<\/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":109197,"type":"question","name":"Forms","excerpt":"I created two different forms and the data entered on both of them is saved in the same sheet. How do I get it to save on two separate sheets?","snippet":"I created two different forms and the data entered on both of them is saved in the same sheet. How do I get it to save on two separate sheets?","categoryID":321,"dateInserted":"2023-08-21T14:53:07+00:00","dateUpdated":null,"dateLastComment":"2023-08-21T21:46:32+00:00","insertUserID":165409,"insertUser":{"userID":165409,"name":"mpatton","url":"https:\/\/community.smartsheet.com\/profile\/mpatton","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zDPQszzjyv0!iTHSYpyQ8H0!4mIm1J-gpMN","dateLastActive":"2023-08-21T23:16:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-22T11:03:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":27,"score":null,"hot":3385286979,"url":"https:\/\/community.smartsheet.com\/discussion\/109197\/forms","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109197\/forms","format":"Rich","lastPost":{"discussionID":109197,"commentID":391727,"name":"Re: Forms","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/391727#Comment_391727","dateInserted":"2023-08-21T21:46:32+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-22T11:03:39+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-21T20:23:16+00:00","dateAnswered":"2023-08-21T19:38:23+00:00","acceptedAnswers":[{"commentID":391698,"body":"

You would create the sheet first, then you can click on \"Forms\" in the top right corner of the new sheet to create the form.<\/p>


<\/p>

If you need a bunch of the same columns, You can \"Save as new\" the existing sheet and then just delete whatever you don't need from each sheet.<\/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":109205,"type":"question","name":"Auto Populate Column Data","excerpt":"I have a sheet that I am populating row one with data inputted using an intake form (Form1). I then have a Update form (Form2) that is used by end users to input additional data. I need the data inputted from form1 to auto populate the entire column the data resides in when form2 is submitted. Any suggestions on how to…","snippet":"I have a sheet that I am populating row one with data inputted using an intake form (Form1). I then have a Update form (Form2) that is used by end users to input additional data.…","categoryID":321,"dateInserted":"2023-08-21T16:13:10+00:00","dateUpdated":null,"dateLastComment":"2023-08-21T19:37:00+00:00","insertUserID":162922,"insertUser":{"userID":162922,"name":"MSGFreebird","title":"","url":"https:\/\/community.smartsheet.com\/profile\/MSGFreebird","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtfyipG4v_0PcUXERFavMo9q8-BAK6RWzljovF2sarPztFY=s96-c","dateLastActive":"2023-08-21T22:54:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-22T11:03:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":43,"score":null,"hot":3385285210,"url":"https:\/\/community.smartsheet.com\/discussion\/109205\/auto-populate-column-data","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109205\/auto-populate-column-data","format":"Rich","lastPost":{"discussionID":109205,"commentID":391697,"name":"Re: Auto Populate Column Data","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/391697#Comment_391697","dateInserted":"2023-08-21T19:37:00+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-22T11:03:39+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/QSNSANMKG9JV\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-21T18:39:09+00:00","dateAnswered":"2023-08-21T18:00:47+00:00","acceptedAnswers":[{"commentID":391672,"body":"

Yes. The \"@row\" piece of the formula is looking for the cell within the row of the formula. So on any row where the meta columns are blank, \"@row\" will also return blank.<\/p>


<\/p>

Try this instead:<\/p>

=INDEX([AT-Meta]:[AT-Meta], 1)<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":4965,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics

  • Creating a contact group in Smartsheet?

    嗨,我想创建一个联络小组(即组织p of collaborator emails). I came across a Help post that instructs me to click on the Account Icon and select "Group Management", however, when I click on the icon, I don't have that option. If I select "My Smartsheet Contacts", there is also no option to create contact…

  • Forms

    I created two different forms and the data entered on both of them is saved in the same sheet. How do I get it to save on two separate sheets?

  • Auto Populate Column Data

    I have a sheet that I am populating row one with data inputted using an intake form (Form1). I then have a Update form (Form2) that is used by end users to input additional data. I need the data inputted from form1 to auto populate the entire column the data resides in when form2 is submitted. Any suggestions on how to…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video