When is a column unique?

CycleBagEd
CycleBagEd ✭✭
inSmartsheet Basics

Hi,

I'd like to check what makes a column unique. The sourceheresuggests column name and column type but I thought I had read somewhere that the range of options in the dropdown (for a dropdown / select column type) made a difference too.

I'm hoping that it doesn't make a difference as I have one of my sheets where I need to enable more dropdown options but it is the same column data type as other sheets and needs to be reported on singularly.

thanks

Ed

· Share on Facebook Share on Twitter

Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓

    @CycleBagEd

    In my experience, it's just the column name and type that have to be the same for the data from multiple sheets to be listed in the same column on a report. With regards to dropdown lists, the columns must all be single-select or must all be multi-select. You can't mix those.

    Regards,

    Jeff Reisman,IT Business Analyst & Project Coordinator,Mitsubishi Electric Trane US

    链接:Smartsheet Functions Help Pages链接:Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

    · Share on Facebook Share on Twitter

Answers

Categories

@Kimberley O<\/a> <\/p>

An COUNTIFS Statement is what you are looking for.<\/p>

=COUNTIFS([Test passed?]:[Test passed?], =\"//www.santa-greenland.com/community/discussion/94264/\", [Check if customer cancelled or was no-show]:[Check if customer cancelled or was no-show], =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":[]},{"discussionID":109280,"type":"question","name":"What happened to the Solution Panel icon?","excerpt":"A week or so ago, I saw the new Solution Panel icon and found it so helpful. Last week, it was gone and I found a thread somewhere that said it should be back online 8\/21. However, it's still not there and I can't find the thread to check on updates. When will that feature be available again?","snippet":"A week or so ago, I saw the new Solution Panel icon and found it so helpful. Last week, it was gone and I found a thread somewhere that said it should be back online 8\/21.…","categoryID":321,"dateInserted":"2023-08-22T16:10:43+00:00","dateUpdated":null,"dateLastComment":"2023-08-22T16:48:34+00:00","insertUserID":165485,"insertUser":{"userID":165485,"name":"Nikki R.","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Nikki%20R.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nzjWX6mhAKQ!iVdXotG08bw!7wqUQE6aMh9","dateLastActive":"2023-08-22T16:42:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-23T07:16:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":27,"score":null,"hot":3385445357,"url":"https:\/\/community.smartsheet.com\/discussion\/109280\/what-happened-to-the-solution-panel-icon","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109280\/what-happened-to-the-solution-panel-icon","format":"Rich","lastPost":{"discussionID":109280,"commentID":391904,"name":"Re: What happened to the Solution Panel icon?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/391904#Comment_391904","dateInserted":"2023-08-22T16:48:34+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-23T07:16:23+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-22T16:42:20+00:00","dateAnswered":"2023-08-22T16:34:12+00:00","acceptedAnswers":[{"commentID":391895,"body":"

\n \n https:\/\/community.smartsheet.com\/discussion\/109280\/what-happened-to-the-solution-panel-icon\n <\/a>\n<\/div>\n

Hi, <\/p>

I hope you're well and safe!<\/p>

They slowed down the rollout, but it's coming.<\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":109273,"type":"question","name":"If there is no info in the second date column leave the formula cell empty or say \"incomplete\"","excerpt":"I can either get the calculation to work or I can get it to say Incomplete when the second date is empty. How do I get it to do both?","snippet":"I can either get the calculation to work or I can get it to say Incomplete when the second date is empty. How do I get it to do both?","categoryID":321,"dateInserted":"2023-08-22T15:32:56+00:00","dateUpdated":null,"dateLastComment":"2023-08-22T15:50:17+00:00","insertUserID":165479,"insertUser":{"userID":165479,"name":"Chris_Lloyd","url":"https:\/\/community.smartsheet.com\/profile\/Chris_Lloyd","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BJPvQS46LfI!5FMteRIPY_o!hcfpPpI27mo","dateLastActive":"2023-08-23T00:05:27+00:00","banned":0,"punished":0,"private":true,"label":"✭"},"updateUserID":null,"lastUserID":165479,"lastUser":{"userID":165479,"name":"Chris_Lloyd","url":"https:\/\/community.smartsheet.com\/profile\/Chris_Lloyd","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BJPvQS46LfI!5FMteRIPY_o!hcfpPpI27mo","dateLastActive":"2023-08-23T00:05:27+00:00","banned":0,"punished":0,"private":true,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":27,"score":null,"hot":3385438993,"url":"https:\/\/community.smartsheet.com\/discussion\/109273\/if-there-is-no-info-in-the-second-date-column-leave-the-formula-cell-empty-or-say-incomplete","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109273\/if-there-is-no-info-in-the-second-date-column-leave-the-formula-cell-empty-or-say-incomplete","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":109273,"commentID":391859,"name":"Re: If there is no info in the second date column leave the formula cell empty or say \"incomplete\"","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/391859#Comment_391859","dateInserted":"2023-08-22T15:50:17+00:00","insertUserID":165479,"insertUser":{"userID":165479,"name":"Chris_Lloyd","url":"https:\/\/community.smartsheet.com\/profile\/Chris_Lloyd","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BJPvQS46LfI!5FMteRIPY_o!hcfpPpI27mo","dateLastActive":"2023-08-23T00:05:27+00:00","banned":0,"punished":0,"private":true,"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\/0RVDWZJTQ4LD\/smartsheet.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-22T15:50:00+00:00","dateAnswered":"2023-08-22T15:48:37+00:00","acceptedAnswers":[{"commentID":391857,"body":"

I think this will do what you are looking for:<\/p>

=IF(ISDATE([ASSMT DATE]@row), IF(ISDATE([AUTH'D DATE]@row), [AUTH'D DATE]@row - [ASSMT DATE]@row, \"Incomplete\"))<\/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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]}],"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":4972,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics

  • Counting symbols in two columns

    I am trying to determine a formula that will count the number of "flags" in one column if there is not a symbol in the second column. In the example below, there is only one flag that I want counted. Basically, the green/red/yellow symbol would cancel out counting the red flag if that makes sense.

  • What happened to the Solution Panel icon?

    A week or so ago, I saw the new Solution Panel icon and found it so helpful. Last week, it was gone and I found a thread somewhere that said it should be back online 8/21. However, it's still not there and I can't find the thread to check on updates. When will that feature be available again?

  • If there is no info in the second date column leave the formula cell empty or say "incomplete"

    I can either get the calculation to work or I can get it to say Incomplete when the second date is empty. How do I get it to do both?

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

 Watch video