Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored 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.
Apply text formatting to tasks in card view
I would like to be able to, essentially, apply multiple conditions to rows and be able to see them in card view.
Currently, I have a condition that changes the task bar color based on a dropdown column. I'd like to also have the ability to apply a text-related condtion (changing the text color to red if the due date is within a week, for example) and be able to see that text-format change in card view as well as in grid view.
I have not be able to find a way to accomplish this, but am I missing something?
Thanks!
Comments
-
KrisWalsh ✭✭✭✭✭
I think this will need to be a feature request and it gets my vote.
Travis, Please submit our request for "Cell Formatting in Card View". (Like in Sights)
Currently, cell formatting (including colors) is not displayed in Card View.
TY!
-
Vote from me as well. In the meantime I've added additional symbols look ups to help visualise the status, but a colour format would help.
Thanks
-
Kennedy Stomps Employee
Hi Alex, Kris, and Tony-- This is a feature that isn't yet available in Card View but our team is considering it for a future product update and I've added your votes for it. Your input is really helpful as we prioritize upcoming improvements to the feature, so thank you for taking the time to share it!
-
A vote from me too!
Thanks!
-
Kennedy Stomps Employee
Hi Claire-- I've added your vote!
-
A vote for me too..
-
Kennedy Stomps Employee
I've added your vote, Robert!
-
Jim Y ✭
another vote for this!
-
Bill Stadler ✭✭
Please add my vote as well. Would be very helpful.
-
Omar ✭
I'd like to add my vote please.
Also, it has been a couple of years since this was being worked on. Any chance it's already in production, and I'm just not doing something right?
-
...another here
-
razdrhj ✭
Really need this feature. A lot of my staff use the card view but can only see format changes in the grid view. Voting for this feature.
Categories
Instead of applying the formula to \"Multiselect Text String\" row, did you tried with \"Multiselect Values\" row?<\/p>
=IF(HAS([Multiselect Values]@row, [Component ID]@row), \"MATCH\", \"NO MATCH\")<\/p>
Thank you,<\/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":109493,"type":"question","name":"I am having trouble using \"And\", \"OR\" & \"Countif(s)\" to build a formula.","excerpt":"Hello, I am attempting to come up with a sheet summary formula that counts cells if they meet at least one of 3 different statuses in the same column, AND also meet one of 5 different statuses in a separate column. So using the screenshot I've provided as an example (although it doesn't have 5 different statuses in the…","snippet":"Hello, I am attempting to come up with a sheet summary formula that counts cells if they meet at least one of 3 different statuses in the same column, AND also meet one of 5…","categoryID":322,"dateInserted":"2023-08-25T20:03:21+00:00","dateUpdated":null,"dateLastComment":"2023-08-26T00:34:49+00:00","insertUserID":165710,"insertUser":{"userID":165710,"name":"SmarsheetNewb","url":"https:\/\/community.smartsheet.com\/profile\/SmarsheetNewb","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-26T00:33:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-27T02:16:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":26,"score":null,"hot":3386005690,"url":"https:\/\/community.smartsheet.com\/discussion\/109493\/i-am-having-trouble-using-and-or-countif-s-to-build-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109493\/i-am-having-trouble-using-and-or-countif-s-to-build-a-formula","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":109493,"commentID":392692,"name":"Re: I am having trouble using \"And\", \"OR\" & \"Countif(s)\" to build a formula.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392692#Comment_392692","dateInserted":"2023-08-26T00:34:49+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-27T02:16:35+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-26T00:33:25+00:00","dateAnswered":"2023-08-25T20:44:12+00:00","acceptedAnswers":[{"commentID":392662,"body":"
Try this:<\/p>
=COUNTIFS([Item Number]:[Item Number], OR(@cell = \"C001\", @cell = \"COO2\", @cell = \"COO3\", @cell = \"COO4\"), [Status]:[Status], OR(@cell = \"Green\", @cell = \"Yellow\", @cell = \"Red\"))<\/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":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":109500,"type":"question","name":"Auto-populate emails on a \"contact list\" column","excerpt":"I have a Form created for internal employees where they can submit request tickets to my department. We all have an account with Smartsheet. One of our columns (\"Requestor Name\") is in the Form where they type in their names. The \"Requestor Name\" column is a Contac List column. My issue here is, how can I have Smartsheet…","snippet":"I have a Form created for internal employees where they can submit request tickets to my department. We all have an account with Smartsheet. One of our columns (\"Requestor Name\")…","categoryID":321,"dateInserted":"2023-08-25T21:43:36+00:00","dateUpdated":"2023-08-25T21:44:14+00:00","dateLastComment":"2023-08-25T22:14:15+00:00","insertUserID":164850,"insertUser":{"userID":164850,"name":"ocanel","title":"Analyst","url":"https:\/\/community.smartsheet.com\/profile\/ocanel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-27T06:55:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":164850,"lastUserID":165374,"lastUser":{"userID":165374,"name":"Shanky Paul","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Shanky%20Paul","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtcAdE60g-MBEj1rR28GVz9zn6RmbZsmEQm5EiEV=s96-c","dateLastActive":"2023-08-27T08:29:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":25,"score":null,"hot":3386002071,"url":"https:\/\/community.smartsheet.com\/discussion\/109500\/auto-populate-emails-on-a-contact-list-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109500\/auto-populate-emails-on-a-contact-list-column","format":"Rich","tagIDs":[204,247,334,448,527],"lastPost":{"discussionID":109500,"commentID":392677,"name":"Re: Auto-populate emails on a \"contact list\" column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392677#Comment_392677","dateInserted":"2023-08-25T22:14:15+00:00","insertUserID":165374,"insertUser":{"userID":165374,"name":"Shanky Paul","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Shanky%20Paul","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtcAdE60g-MBEj1rR28GVz9zn6RmbZsmEQm5EiEV=s96-c","dateLastActive":"2023-08-27T08:29:18+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-27T06:55:03+00:00","dateAnswered":"2023-08-25T22:14:15+00:00","acceptedAnswers":[{"commentID":392677,"body":"
Hi, <\/p>
Add a \"Created By\" column in your sheet and turn on \"Required smartsheet login to access your form\" in your form setting. So that whoever fills out the form, their email id will be automatically captured in \"created by\" column. This will replace your \"Requestor Name\" column. <\/p>
Thank you!<\/p>
<\/p>