Welcome to the Smartsheet Forum Archives


这个论坛的帖子不再监视for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.

BACKGROUND COLOR!

Can we have more colors??? i stare at smartsheet all day long and would like some new color options!!! thanksSealed

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    I don't need any more colors. I have multiple monitors and Smartsheet already looks different depending on which is being used.

    YMMV

    Craig

  • Don't you use background colors for different rows? They can't all look different on different monitors I also have multiple monitors. Just think the rows could use some bright colors:)

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    I do, but if there are more than half-dozen, I start to lose track of what they mean, and just about all of them look at least slightly, some more so, different on different monitors. My laptop's graphics card is crap.

    I also suspect that the graphics eats into my browser's processing power.

    Craig

  • I also find myself wanting more colors (or at least the ability to define custom colors).

    I suppose some of this desire is due to migrating existing Excel workbooks to Smartsheet and wanting to keep some of the formatting the same. But I also like to be able to customize the crap out of any tool I use, so the limited pallette is a little disappointing.

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    This may be age speaking, but I have found that I spent a lot of time "re-customizing" for every migration and so each one has been less and less one-offs.

    If I had to rehang the curtains every time I opened the window in my house, I'd probably stop opening the window so much.

    Not opposed to more colors, just won't likely use them.

    I also sat in a two hour meeting one time (I was nearly chained to the desk and gagged) with senior management discussing the color of the new carpet. Maybe I'm having flashbacks. Shudder.

    Craig

  • Hi All—I'll add your votes for having more color formatting options in the app, and for...not having more color formatting options?

    I'd hate for Smartsheet to be a trigger for J. Craig's carpet meeting trauma.

  • LaughingWonderful. Wouldn't want any traumas haha

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    因为会议成本超过2500美元the number of people and their salaries in the room.

    Craig

  • Yoann
    Yoann
    edited 01/31/17

    Please add my vote as I definetely need the ability to define my own colors. Now with the Sights and Cards options, the tool is widely spreading in the company and we need to make nice presentations consistent with the colors of the company graphic charter.

  • Shaine Greenwood
    Shaine Greenwood Employee
    edited 01/31/17

    Hi Yoann,

    Read you loud and clear; I've passed your feedback along to our Product team as well.

    Thanks for the input!

  • Mohammad Khairuzzaman
    edited 03/23/17

    Need more/custom backround colors options. Not everyone will need it but some doSmile

  • Count me as a vote for more colors. The current palette does not include my Company colors (or even a close approximation). We have many clients that also have palettes they prefer. We would like to offer the advantages of Smartsheet to our clients during projects and customize to their style.

  • Please add my vote to theNEED for COLORadditions. I need to be able to visually group/ highlight info in a large amount of data, and I have run out of colors many times already. It would be a great accommodation to allow a wider range of creative 'opportunity'.

    Thank you!

  • I use Smartsheet for a lot of my corporate client meetings. I would like to customize the colors for each company but with the current palette, it is incredibly difficult. The colors are too bright and distracting. I would like more options.

  • Sean Robins
    Sean Robins ✭✭
    edited 10/24/18

    Is there any update to where this is at? It would be great to be able to select additional formatting colors for charts, cards, and other views in smartsheet. Any possible way to get things set to select from one of the following: PMS C/U, CMYK, RGB, or #hex? This would allow individuals to brand all aspects of a dashboard without needing to create external images and import them into a dashboard. Thank you!

    Sean

This discussion has been closed.
You will need to make sure your [Date as DateType] column is formatted as Date. This also assumes your [Date as Text Type] column is always in the same format. (Starts with full 10 digit date)<\/p>

=IF([Date as Text Type]@row <> \"//m.santa-greenland.com/community/discussion/comment/\", DATE(VALUE(LEFT([Date as Text Type]@row, 4)), VALUE(MID([Date as Text Type]@row, 6, 2)), VALUE(MID([Date as Text Type]@row, 9, 2))), \"//m.santa-greenland.com/community/discussion/comment/\")<\/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":107082,"type":"question","name":"Automatic Update of Dropdown List?","excerpt":"I saw several discussions on this and I'm wondering if there is a formula or an easy way without a 3rd party to automatically update a dropdown list based on a cell in one sheet? I can create a helper sheet if that would help. Any ideas? I don't believe I have the premium Smartsheets plan. Thank you! Lori","snippet":"I saw several discussions on this and I'm wondering if there is a formula or an easy way without a 3rd party to automatically update a dropdown list based on a cell in one sheet?…","categoryID":322,"dateInserted":"2023-06-29T14:16:13+00:00","dateUpdated":null,"dateLastComment":"2023-06-29T16:05:09+00:00","insertUserID":162337,"insertUser":{"userID":162337,"name":"maineL","title":"Admin. & Course Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/maineL","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!plNXqQdBs_o!2kvQ_7y42f4!PTHvB33mICN","dateLastActive":"2023-06-29T16:57:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":162337,"lastUser":{"userID":162337,"name":"maineL","title":"Admin. & Course Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/maineL","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!plNXqQdBs_o!2kvQ_7y42f4!PTHvB33mICN","dateLastActive":"2023-06-29T16:57:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":36,"score":null,"hot":3376107682,"url":"https:\/\/community.smartsheet.com\/discussion\/107082\/automatic-update-of-dropdown-list","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107082\/automatic-update-of-dropdown-list","format":"Rich","lastPost":{"discussionID":107082,"commentID":383131,"name":"Re: Automatic Update of Dropdown List?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383131#Comment_383131","dateInserted":"2023-06-29T16:05:09+00:00","insertUserID":162337,"insertUser":{"userID":162337,"name":"maineL","title":"Admin. & Course Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/maineL","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!plNXqQdBs_o!2kvQ_7y42f4!PTHvB33mICN","dateLastActive":"2023-06-29T16:57:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-29T14:52:00+00:00","dateAnswered":"2023-06-29T14:50:26+00:00","acceptedAnswers":[{"commentID":383100,"body":"

@maineL<\/a>,<\/p>

I haven't seen this possible without the use of a 3rd party integration. I don't believe it is supported natively in Smartsheet. The question comes up all the time though. <\/p>

BRgds,<\/p>

-Ray<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":107083,"type":"question","name":"Excluding data when using COUNTIF","excerpt":"Hi, I have a graph on a dashboard based on the status of a project using the following formula for each status: =COUNTIF({Optimisation List Range 2}, \"Unallocated\") We do not want to pull through any project that is on hold but want to keep the status as it is on this column so have an additional column with the RAG Status…","snippet":"Hi, I have a graph on a dashboard based on the status of a project using the following formula for each status: =COUNTIF({Optimisation List Range 2}, \"Unallocated\") We do not want…","categoryID":322,"dateInserted":"2023-06-29T14:45:28+00:00","dateUpdated":null,"dateLastComment":"2023-06-29T15:24:40+00:00","insertUserID":162412,"insertUser":{"userID":162412,"name":"JennyB.","url":"https:\/\/community.smartsheet.com\/profile\/JennyB.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-29T15:20:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162412,"lastUser":{"userID":162412,"name":"JennyB.","url":"https:\/\/community.smartsheet.com\/profile\/JennyB.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-29T15:20:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3376103408,"url":"https:\/\/community.smartsheet.com\/discussion\/107083\/excluding-data-when-using-countif","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107083\/excluding-data-when-using-countif","format":"Rich","lastPost":{"discussionID":107083,"commentID":383116,"name":"Re: Excluding data when using COUNTIF","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383116#Comment_383116","dateInserted":"2023-06-29T15:24:40+00:00","insertUserID":162412,"insertUser":{"userID":162412,"name":"JennyB.","url":"https:\/\/community.smartsheet.com\/profile\/JennyB.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-29T15:20:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-29T15:24:21+00:00","dateAnswered":"2023-06-29T15:16:19+00:00","acceptedAnswers":[{"commentID":383110,"body":"

@JennyB.<\/a> <\/p>

If I'm understanding your question correctly, you want to counts from one column but want to exclude projects that have an \"On Hold\" status in a second column. If so, then a countifs formula would work:<\/p>

=COUNTIFS({Column to Count}, \"Unallocated\", {Other column}, <>\"On Hold\")<\/p>

Hope this helps!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&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":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts