View By Drop Down - Card View
How can I add conditions to the ' View By" drop down in card view. In the demonstration it shows multiple including " assigned to, progress etc" . Mine only gives options for two- progress and priority.
Answers
-
Kelly Moore ✭✭✭✭✭✭
Hello Nikki
Card view 'views' come from columns with dropdown lists, symbols or contacts. It appears you have 2 columns in your sheet that meet that criteria. The number of lanes either one of those views yield will depend on how many dropdown values (or symbols) were associated with those columns.
Did that answer your question?
-
Nikki Martyn ✭✭Hi KDM.
Thank you for your reply. I do have a column for contacts in my sheet- it`s not titled contacts but the column criteria is for contacts and it is called VPX lead. Shouldn`t that then appear in my card view views?
-
Kelly Moore ✭✭✭✭✭✭
Hi Nikki,
It's my understanding that single select contact fields should show up. Contact columns that allow multiple contacts don't show up
Help Article Resources
Categories
=SUMIFS({Deliverables}, {Work Type}, HAS(@cell, \"Reprint\"), {Fiscal Quarter}, HAS(@cell, \"Q1\"), {Fiscal Year}, HAS(@cell, \"FY24\"))<\/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":112303,"type":"question","name":"HLOOKUP for first value not blank?","excerpt":"I've tackled this a few ways already but everything comes back with errors. Here's the latest - =INDEX([T1 BI Blend Options]1:[T1 Data Recon Options]1, MATCH(false, ISBLANK([T1 BI Blend Options]1:[T1 Data Recon Options]1), 0)) Does 'ISBLANK' come back with a value different than false? I tried using the ISBLANK formula…","snippet":"I've tackled this a few ways already but everything comes back with errors. Here's the latest - =INDEX([T1 BI Blend Options]1:[T1 Data Recon Options]1, MATCH(false, ISBLANK([T1 BI…","categoryID":322,"dateInserted":"2023-10-27T22:32:31+00:00","dateUpdated":null,"dateLastComment":"2023-10-30T15:33:23+00:00","insertUserID":169212,"insertUser":{"userID":169212,"name":"maggie82","url":"https:\/\/community.smartsheet.com\/profile\/maggie82","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!YStHGA0NUrg!wkHG_1FtuX4!aHvG88J3jzE","dateLastActive":"2023-10-30T16:37:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":169212,"lastUser":{"userID":169212,"name":"maggie82","url":"https:\/\/community.smartsheet.com\/profile\/maggie82","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!YStHGA0NUrg!wkHG_1FtuX4!aHvG88J3jzE","dateLastActive":"2023-10-30T16:37:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":32,"score":null,"hot":3397127754,"url":"https:\/\/community.smartsheet.com\/discussion\/112303\/hlookup-for-first-value-not-blank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112303\/hlookup-for-first-value-not-blank","format":"Rich","lastPost":{"discussionID":112303,"commentID":402229,"name":"Re: HLOOKUP for first value not blank?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402229#Comment_402229","dateInserted":"2023-10-30T15:33:23+00:00","insertUserID":169212,"insertUser":{"userID":169212,"name":"maggie82","url":"https:\/\/community.smartsheet.com\/profile\/maggie82","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!YStHGA0NUrg!wkHG_1FtuX4!aHvG88J3jzE","dateLastActive":"2023-10-30T16:37:13+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/EGSG8YGDDHNQ\/image.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EGSG8YGDDHNQ\/image.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EGSG8YGDDHNQ\/image.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EGSG8YGDDHNQ\/image.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EGSG8YGDDHNQ\/image.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EGSG8YGDDHNQ\/image.png"},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-30T15:30:14+00:00","dateAnswered":"2023-10-28T01:14:38+00:00","acceptedAnswers":[{"commentID":402142,"body":"
![\"HLOOKUP](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/HUZI7QZVV65N\/hlookup-like.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
