@happinessisland<\/a>,<\/p>What is likely happening here is that the columns from the various sheets are different column types. For example, one sheet might have the Contacts column as a Contact List, another might have it as a Dropdown List, and yet another might have it as Text. Each column type will show up separately on a report. If you want the data to combine into a single report column, they should all be the same Column Type.<\/p>
I would suggest changing them all to the same type and then educating people using those sheets on the preferred way to use Contacts columns in your process.<\/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":527,"urlcode":"columns","name":"columns"}]},{"discussionID":110378,"type":"question","name":"Is it advisable to migrate from- Smartsheet to Jira?","excerpt":"My team has been planning to migrate all our projects from Smartsheet to Jira and we would like to hear from a professional if it is advisable to do so.","snippet":"My team has been planning to migrate all our projects from Smartsheet to Jira and we would like to hear from a professional if it is advisable to do so.","categoryID":321,"dateInserted":"2023-09-18T06:43:45+00:00","dateUpdated":null,"dateLastComment":"2023-09-18T08:34:13+00:00","insertUserID":166661,"insertUser":{"userID":166661,"name":"Ghaven","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Ghaven","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-18T08:32:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":166661,"lastUser":{"userID":166661,"name":"Ghaven","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Ghaven","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-18T08:32:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":33,"score":null,"hot":3390046678,"url":"https:\/\/community.smartsheet.com\/discussion\/110378\/is-it-advisable-to-migrate-from-smartsheet-to-jira","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110378\/is-it-advisable-to-migrate-from-smartsheet-to-jira","format":"Rich","lastPost":{"discussionID":110378,"commentID":395681,"name":"Re: Is it advisable to migrate from- Smartsheet to Jira?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/395681#Comment_395681","dateInserted":"2023-09-18T08:34:13+00:00","insertUserID":166661,"insertUser":{"userID":166661,"name":"Ghaven","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Ghaven","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-18T08:32:12+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-09-18T08:33:16+00:00","dateAnswered":"2023-09-18T08:31:46+00:00","acceptedAnswers":[{"commentID":395680,"body":"
@Ghaven<\/a> - The choice between Smartsheet and Jira really comes down to what you're looking to get done and who's on your team. If we're talking about a dev-heavy team working on complex, technical projects with tons of requirements, then Jira's a no-brainer. It's built for that level of detail and collaboration. But hey, if your team's a mix of tech and non-tech folks, or you're juggling different types of projects, Smartsheet's versatility and user-friendly layout could be the better route. Just keep in mind things like cost, how well these platforms play with your existing tech stack, and the time it'll take for everyone to get up to speed on a new system. So, it's not a one-size-fits-all answer; it's about aligning the tool with your team's specific needs and workflow. Hope that helps a little 👍️<\/span><\/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":110373,"type":"question","name":"10 digit fixed numeric field","excerpt":"Hi, I have few fields where I want to add a validation\/control user to force doing the correct entry - e.g. PO# shouldn't be more or less than 10 digits. Is it possible? They do these entries via Form. I see their are new validations numeric\/text etc...they don't help what I need. Also, Can we trigger any flash alert for…","snippet":"Hi, I have few fields where I want to add a validation\/control user to force doing the correct entry - e.g. PO# shouldn't be more or less than 10 digits. Is it possible? They do…","categoryID":321,"dateInserted":"2023-09-17T21:57:39+00:00","dateUpdated":null,"dateLastComment":"2023-09-18T11:13:34+00:00","insertUserID":165902,"insertUser":{"userID":165902,"name":"Arts B.","url":"https:\/\/community.smartsheet.com\/profile\/Arts%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-19T16:50:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":165902,"lastUser":{"userID":165902,"name":"Arts B.","url":"https:\/\/community.smartsheet.com\/profile\/Arts%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-19T16:50:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":23,"score":null,"hot":3390024673,"url":"https:\/\/community.smartsheet.com\/discussion\/110373\/10-digit-fixed-numeric-field","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110373\/10-digit-fixed-numeric-field","format":"Rich","tagIDs":[204,254],"lastPost":{"discussionID":110373,"commentID":395685,"name":"Re: 10 digit fixed numeric field","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/395685#Comment_395685","dateInserted":"2023-09-18T11:13:34+00:00","insertUserID":165902,"insertUser":{"userID":165902,"name":"Arts B.","url":"https:\/\/community.smartsheet.com\/profile\/Arts%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-19T16:50:17+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-09-18T11:33:19+00:00","dateAnswered":"2023-09-18T11:13:34+00:00","acceptedAnswers":[{"commentID":395685,"body":"Thanks, Tim, for replying. Yes, I read more on the community about and found the same workaround....I already applied it.<\/p>
(my users are floor workers and works in the shift-only issue here is they don't check emails that often.) so this workaround has limitation in this case. But I'll mark this close as, no actual solution available in Smartsheet.<\/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":204,"urlcode":"forms","name":"Forms"},{"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":5094,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
Trending in Smartsheet Basics
Several Columns Have the Same Name I have several workspaces that people use to make different sheets. The problem is that whenever I try to make a report for someone and I'm sorting out which columns to include, there are several columns with the same name. For instance, if the column name was 'Contacts', there are four columns named 'Contacts' which each…
Is it advisable to migrate from- Smartsheet to Jira? My team has been planning to migrate all our projects from Smartsheet to Jira and we would like to hear from a professional if it is advisable to do so.
10 digit fixed numeric field Hi, I have few fields where I want to add a validation/control user to force doing the correct entry - e.g. PO# shouldn't be more or less than 10 digits. Is it possible? They do these entries via Form. I see their are new validations numeric/text etc...they don't help what I need. Also, Can we trigger any flash alert for…
Leibel S ✭✭✭✭✭✭
