Add Ons and Integrations

Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, WorkApps, or Resource Management. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.

Discussion List

to something else","excerpt":"Hello, I was wondering if there is a way to change the name of fields that are blank in the pivot table so they are labeled as ? Would it be possible to change this to \"Unassigned\" or something like that? This pivot will update a lot so I can't just change it once, it would need to stick after updates. Thank you","categoryID":343,"dateInserted":"2020-05-05T13:23:47+00:00","dateUpdated":"2022-06-14T14:36:57+00:00","dateLastComment":"2020-05-06T18:05:05+00:00","insertUserID":93956,"insertUser":{"userID":93956,"name":"Brian Campbell","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Brian%20Campbell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/DD9DQEP8RM65\/nZX0DUWQ2IMP3.jpg","dateLastActive":"2022-08-04T19:51:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2023-01-13T00:53:49+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":62,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/68042\/pivot-app-change-name-of-to-something-else","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68042\/pivot-app-change-name-of-to-something-else","format":"rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":67878,"type":"question","name":"Pivot not updating formula column in child rows","excerpt":"Hello I am working with the pivot app and created a new column that is basically (ColumnName@row-ColumnName2@row). There are 2 sections in the row data and one section(Example: Team) will add this formula since it is the parent, but the formula won't carry when the second section of row data (Example: Employee Name) has…","categoryID":343,"dateInserted":"2020-04-29T16:36:02+00:00","dateUpdated":"2022-06-14T14:36:56+00:00","dateLastComment":"2020-05-06T14:11:43+00:00","insertUserID":93956,"insertUser":{"userID":93956,"name":"Brian Campbell","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Brian%20Campbell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/DD9DQEP8RM65\/nZX0DUWQ2IMP3.jpg","dateLastActive":"2022-08-04T19:51:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2023-01-13T00:53:49+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":72,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/67878\/pivot-not-updating-formula-column-in-child-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67878\/pivot-not-updating-formula-column-in-child-rows","format":"rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":67728,"type":"question","name":"Dates and months issue","excerpt":"Hello, Are there others or many experienceing issues that Smartsheet swaps months to dates and vica versa? I have now had this issue several times and informed SS about it. For some reason the issue goes away after letting SS know (maybe they do something) about it but then it comes back after a month or so. This has now…","categoryID":343,"dateInserted":"2020-04-24T08:42:05+00:00","dateUpdated":"2022-06-14T14:36:56+00:00","dateLastComment":"2020-05-06T09:19:50+00:00","insertUserID":94946,"insertUser":{"userID":94946,"name":"Risto Nykanen","url":"https:\/\/community.smartsheet.com\/profile\/Risto%20Nykanen","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5WDYOclSahQ!UiNfn5RHe7o!LsiinjAzZCz","dateLastActive":"2022-09-01T14:12:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2023-01-13T00:53:49+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":62,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/67728\/dates-and-months-issue","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67728\/dates-and-months-issue","format":"rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":67955,"type":"question","name":"Archiving Control Center Projects","excerpt":"Good morning! I was wondering if anyone knows how to archive a project in Control Center? I tried to go into the program and have been searching on how to execute archiving projects but have been unable to find any information. Does anyone have any information to share? Thanks.","categoryID":343,"dateInserted":"2020-05-01T14:24:30+00:00","dateUpdated":"2022-06-14T14:36:57+00:00","dateLastComment":"2020-05-05T13:00:35+00:00","insertUserID":86431,"insertUser":{"userID":86431,"name":"bradleyesmith86431","url":"https:\/\/community.smartsheet.com\/profile\/bradleyesmith86431","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GgnY7dDALFT61pNAAdU0ZSFD4NbvQNRT0f7-rzLqA","dateLastActive":"2022-01-20T17:05:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":91551,"lastUser":{"userID":91551,"name":"Sean Morgan","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Sean%20Morgan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-06\/a4\/03\/na403d870f03ea953400c0ccf39cb374e.jpg","dateLastActive":"2022-12-13T09:48:24+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":435,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/67955\/archiving-control-center-projects","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67955\/archiving-control-center-projects","format":"rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":68034,"type":"question","name":"Looking to use Appsheet or Evernote","excerpt":"I am searching for the right app to help with the communication between the office and field. We currently use another app called Builder Trend. It's a way for our designers and staff to see the progress of the field installation by pictures and \"to do\" lists. Problems with with the app: 1.) we started using it before…","categoryID":343,"dateInserted":"2020-05-04T23:47:17+00:00","dateUpdated":"2022-06-14T14:36:57+00:00","dateLastComment":"2020-05-05T10:33:01+00:00","insertUserID":99786,"insertUser":{"userID":99786,"name":"ginamt3","url":"https:\/\/community.smartsheet.com\/profile\/ginamt3","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!AwjPh0ixPxQ!ZBDP2WyJZ-Y!aqgvGoSn11r","dateLastActive":"2023-01-03T11:44:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2023-01-13T00:24:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":52,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/68034\/looking-to-use-appsheet-or-evernote","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68034\/looking-to-use-appsheet-or-evernote","format":"rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/383\/FJA1WT9LBD5B.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2020-04-30 at 7.17.04 PM.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":67896,"type":"question","name":"Pivot table showing zeros","excerpt":"I have three locations and different tasks associated with each location. I would like to set up a pivot table that shows me the average status of every task at each location. I set up a column that is using a formula to convert the progress bar status into a numerical value that I am trying to use in my pivot table. Can…","categoryID":343,"dateInserted":"2020-04-30T01:55:36+00:00","dateUpdated":"2022-06-14T14:36:57+00:00","dateLastComment":"2020-05-01T20:07:45+00:00","insertUserID":120831,"insertUser":{"userID":120831,"name":"Allie Forbes","url":"https:\/\/community.smartsheet.com\/profile\/Allie%20Forbes","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!B_DDAQ0yXvQ!hBFCIXFEJ_o!GxrrGNuvyRj","dateLastActive":"2021-02-24T21:25:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-01-12T21:02:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":143,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/67896\/pivot-table-showing-zeros","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67896\/pivot-table-showing-zeros","format":"rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/854\/7FXZSPDWKAAL.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-05-01T20:00:25+00:00","dateAnswered":"2020-05-01T19:58:52+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":67836,"type":"question","name":"Smartsheet bot not generating in Gmail inbox Hangouts Chat.","excerpt":"So I'm trying to implement Smartsheets to notify our staff via Hangouts Chat. We use Gsuites for our company and rather than bombard our inbox with notifications I'm wanting to get hangouts chat to work to notify staff since we do most of our communication through that. I got the bot set up according to the instructions…","categoryID":343,"dateInserted":"2020-04-28T16:13:42+00:00","dateUpdated":"2022-06-14T14:36:56+00:00","dateLastComment":"2020-05-01T11:19:57+00:00","insertUserID":99501,"insertUser":{"userID":99501,"name":"Aaron D.","url":"https:\/\/community.smartsheet.com\/profile\/Aaron%20D.","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GhFB2K-xjNbxqPiulCFHQhZ9kNYYICGaKicy7fH","dateLastActive":"2020-04-29T18:31:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":91551,"lastUser":{"userID":91551,"name":"Sean Morgan","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Sean%20Morgan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-06\/a4\/03\/na403d870f03ea953400c0ccf39cb374e.jpg","dateLastActive":"2022-12-13T09:48:24+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":72,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/67836\/smartsheet-bot-not-generating-in-gmail-inbox-hangouts-chat","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67836\/smartsheet-bot-not-generating-in-gmail-inbox-hangouts-chat","format":"rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":67385,"type":"question","name":"Is Live Data Connector compatible with Windows Server 2019 & 2020?","excerpt":"Hi, docs say only through Win Server 2012, hoping documentation out of date. Thanks","categoryID":343,"dateInserted":"2020-04-13T20:30:07+00:00","dateUpdated":"2022-06-14T14:36:54+00:00","dateLastComment":"2020-04-29T21:36:36+00:00","insertUserID":120477,"insertUser":{"userID":120477,"name":"CovidPlasmaSaveALife","url":"https:\/\/community.smartsheet.com\/profile\/CovidPlasmaSaveALife","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-04-19T19:59:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":45236,"lastUser":{"userID":45236,"name":"Alejandra","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Alejandra","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-04\/8a\/fe\/n8afeceb592ad5845f46c7d931defba07.JPG","dateLastActive":"2020-05-15T18:56:51+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":72,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/67385\/is-live-data-connector-compatible-with-windows-server-2019-2020","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67385\/is-live-data-connector-compatible-with-windows-server-2019-2020","format":"rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"tags":[{"tagID":277,"urlcode":"Integrations","name":"Integrations"}],"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}]},{"discussionID":67796,"type":"question","name":"Gov connection in Power BI?","excerpt":"Is there a way to make Smartsheetgov data available in Power BI? The existing Power BI Smartsheet app\/connector only seems to connect to a Smartsheet account, but not a Smartsheetgov account, and I don't see any way to customize it to change the connection string. I do see that the \"differences between smartsheet gov and…","categoryID":343,"dateInserted":"2020-04-27T17:37:02+00:00","dateUpdated":"2022-06-14T14:36:56+00:00","dateLastComment":"2020-04-29T15:00:22+00:00","insertUserID":120919,"insertUser":{"userID":120919,"name":"Jamie Bedford","url":"https:\/\/community.smartsheet.com\/profile\/Jamie%20Bedford","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-28T16:49:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2023-01-13T00:53:49+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":192,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/67796\/gov-connection-in-power-bi","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67796\/gov-connection-in-power-bi","format":"rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/136\/EMO4I4TDSPFX.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet gov commercial differences - Microsoft Office 365.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-04-29T15:13:30+00:00","dateAnswered":"2020-04-29T15:00:22+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"tags":[{"tagID":263,"urlcode":"Government","name":"Government"}],"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}]},{"discussionID":39661,"type":"discussion","name":"Consolidated Dashboard or PowerPoint","excerpt":"OK sleuths, this one is for you. We are an organization that loves powerpoint, and no matter what dashboards we create, a powerpoint presentation is typically still needed. We need a way to consolidate our project status in one easy document or dashboard. Is there any way to create the either of the two solutions below…","categoryID":343,"dateInserted":"2019-01-23T11:10:06+00:00","dateUpdated":"2022-06-14T14:36:23+00:00","dateLastComment":"2020-04-29T08:49:32+00:00","insertUserID":10908,"insertUser":{"userID":10908,"name":"Tana Rucker","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Tana%20Rucker","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!u7jAV67lpKQ!uj9B90Lbm_o!nhgm7_URp7Q","dateLastActive":"2022-07-13T18:49:55+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers Alumni"},"updateUserID":91566,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2023-01-13T00:24:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":2745,"score":1,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/39661\/consolidated-dashboard-or-powerpoint","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/39661\/consolidated-dashboard-or-powerpoint","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"tags":[{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":270,"urlcode":"Technology","name":"Technology"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":278,"urlcode":"Importing and Exporting","name":"Importing and Exporting"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Categories

Popular Tags

@Peggy<\/a> <\/p>

You're right about adding the Product Lines to the 2nd sheet with the department\/users. After you do that, on the 1st sheet you'll want to use an INDEX\/MATCH formula which drags in the user who needs the notification. You'll match against the product line listed on sheet 1 and 2.<\/p>

Once you've got that setup and working, on the 1st sheet you can create an automation which is triggered by the date field and alerts the contact field which is the user who's INDEX\/MATCHed from the 2nd sheet.<\/p>"},{"commentID":357032,"body":"

@Peggy<\/a> <\/p>

You may need to use an INDEX\/COLLECT formula instead if you have multiple people listed on the 2nd sheet and you want to pull in someone with a specific title. COLLECT will help you specify multiple criteria which would be the product line criteria and the person's title criteria.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-12 23:19:42","updateUser":{"userID":35911,"name":"Peggy","url":"https:\/\/community.smartsheet.com\/profile\/Peggy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7Htee2AaTfQ!htPdobx0PT4!J2mAMiaMDmW","dateLastActive":"2023-01-12T23:19:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}}},"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":99612,"type":"question","name":"Issues with cells in a spreadsheet on computer assets","excerpt":"It appears that a large number of cells in the spreadsheet, in a column for costs, have changed from dollar amounts to dates. The column type is set to Text\/Number. Any idea on why this might happen, all cells have the change dat as 8\/10\/22. Thanks in advance, Joe Busch jbusch@urban.org","categoryID":321,"dateInserted":"2023-01-12T15:58:33+00:00","dateUpdated":null,"dateLastComment":"2023-01-12T20:42:49+00:00","insertUserID":11262,"insertUser":{"userID":11262,"name":"Joe Busch","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Busch","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-12T20:42:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":11262,"lastUser":{"userID":11262,"name":"Joe Busch","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Busch","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-12T20:42:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":29,"score":null,"hot":3347097682,"url":"https:\/\/community.smartsheet.com\/discussion\/99612\/issues-with-cells-in-a-spreadsheet-on-computer-assets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99612\/issues-with-cells-in-a-spreadsheet-on-computer-assets","format":"Rich","lastPost":{"discussionID":99612,"commentID":356984,"name":"Re: Issues with cells in a spreadsheet on computer assets","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/356984#Comment_356984","dateInserted":"2023-01-12T20:42:49+00:00","insertUserID":11262,"insertUser":{"userID":11262,"name":"Joe Busch","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Busch","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-12T20:42:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-12T18:56:53+00:00","dateAnswered":"2023-01-12T17:57:14+00:00","acceptedAnswers":[{"commentID":356943,"body":"

Have you looked at the activity log and\/or cell history?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-12 18:56:53","updateUser":{"userID":11262,"name":"Joe Busch","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Busch","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-12T20:42:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":99598,"type":"question","name":"Difference between Unlicensed users and...","excerpt":"Hello, I just discovered i have a number of license requests these staff can access the sheets that have been shared with them but are not listed in either our licensed or unlicensed users. What is the difference between these?","categoryID":321,"dateInserted":"2023-01-12T12:15:26+00:00","dateUpdated":null,"dateLastComment":"2023-01-12T15:37:04+00:00","insertUserID":146602,"insertUser":{"userID":146602,"name":"ldavenportHAP","url":"https:\/\/community.smartsheet.com\/profile\/ldavenportHAP","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-12T15:36:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":146602,"lastUser":{"userID":146602,"name":"ldavenportHAP","url":"https:\/\/community.smartsheet.com\/profile\/ldavenportHAP","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-12T15:36:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":32,"score":null,"hot":3347064750,"url":"https:\/\/community.smartsheet.com\/discussion\/99598\/difference-between-unlicensed-users-and","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99598\/difference-between-unlicensed-users-and","format":"Rich","lastPost":{"discussionID":99598,"commentID":356897,"name":"Re: Difference between Unlicensed users and...","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/356897#Comment_356897","dateInserted":"2023-01-12T15:37:04+00:00","insertUserID":146602,"insertUser":{"userID":146602,"name":"ldavenportHAP","url":"https:\/\/community.smartsheet.com\/profile\/ldavenportHAP","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-12T15:36:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"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\/W6KTJCW73D21\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-12T15:36:36+00:00","dateAnswered":"2023-01-12T14:05:02+00:00","acceptedAnswers":[{"commentID":356865,"body":"

What you have run into is a situation where a user has a free account that is not technically in your Smartsheet organization, and therefore you cannot see it or administer it; you can only see it on Sheet Access reports and in the Share list on sheets the user can access with it. When they click on the upgrade button on their screen, it shows up as a license request for you to work.<\/p>

The users that show up in the Unlicensed Users list either were previously licensed, or the accounts were created by the Smartsheet System Admin with the user being \"invited\" into your Smartsheet org.<\/p>

My org used to be this way. In User Management, I used to only be able to see licensed users, formerly licensed users, and users I had specifically added myself through User Management.<\/p>

When I implemented User Auto-Provisioning in Smartsheet for our domain, any users with our email domain who create accounts are automatically added to our unlicensed user list. Users in our domain with existing accounts are provisioned into our org upon their next login. Now I can download login history for all users in our domain, licensed or not, no matter if they created their account or I did. I can update their profiles, add roles, etc. I also control what happens when a free user in our domain clicks the upgrade button: they get taken to my own Smartsheet license request form, which explains the criteria for being given a license, and which when submitted creates a ticket for me to address. There are also options for custom help screens - what a domain user sees when clicking on the ? icon for help - as well as custom welcome screens - such as a screen outlining your org's Smartsheet usage policies and requiring a user acknowledgement such as an \"I Agree\" checkbox.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-12 15:36:36","updateUser":{"userID":146602,"name":"ldavenportHAP","url":"https:\/\/community.smartsheet.com\/profile\/ldavenportHAP","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-12T15:36:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">