Workapps
Good day,
We have an enterprise plan with Smartsheet.
Today I created two WorkA
pps - but I keep getting a notification that they need a lisence. I am not sure how to correct this.
Answers
-
Andrée Starå ✭✭✭✭✭✭I hope you're well and safe!
Everyone you share with has to have a Smartsheet License. Otherwise, you'd need to acquire the WorkApps Collaborator Pack to share it with anyone who doesn't have a license.
Make sense?
I hope that helps!
Have a fantastic week & Happy Holidays!
Best,
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
✅了我的帖子(s)帮助或回答你的问题吗tion or solve your problem? Please support the Community bymarking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/7PW7A87EDNZ6\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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":94479,"type":"question","name":"Data Mesh questions - sort and deletion","excerpt":"Hi all I have 2 questions please. When you complete a data mesh to add a new row - it adds it to the target sheet but to the bottom of the sheet. Is there a way you can sort the rows on your source sheet and it will sort in your target sheet? - If not then is there an automation that I can set per target sheet to sort the…","snippet":"Hi all I have 2 questions please. When you complete a data mesh to add a new row - it adds it to the target sheet but to the bottom of the sheet. Is there a way you can sort the…","categoryID":343,"dateInserted":"2022-08-19T17:04:02+00:00","dateUpdated":null,"dateLastComment":"2023-10-25T12:51:23+00:00","insertUserID":80556,"insertUser":{"userID":80556,"name":"Roshni Verappan","url":"https:\/\/community.smartsheet.com\/profile\/Roshni%20Verappan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-25T20:10:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-10-26T13:12:15+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":310,"score":null,"hot":3359169325,"url":"https:\/\/community.smartsheet.com\/discussion\/94479\/data-mesh-questions-sort-and-deletion","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94479\/data-mesh-questions-sort-and-deletion","format":"Rich","lastPost":{"discussionID":94479,"commentID":401562,"name":"Re: Data Mesh questions - sort and deletion","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/401562#Comment_401562","dateInserted":"2023-10-25T12:51:23+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-10-26T13:12:15+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-26T21:32:26+00:00","dateAnswered":"2022-08-23T11:09:56+00:00","acceptedAnswers":[{"commentID":340710,"body":"
Hi @Roshni Verappan<\/a> <\/p> 1 . DataMesh adds new rows to the bottom of the sheet, as you've found. If you need your sheet constantly sorted, I would recommend building a Report<\/strong> off of the destination sheet to bring in all the rows from this second sheet in the order you'd like! <\/p> A Report will automatically Sort based on your Report criteria as new rows are added to the source sheet. (See: Build a row report<\/a> & Sort Your Report Results with Report Builder<\/a>)<\/p> 2 . DataMesh currently does not delete rows from the Destination sheet, no. The row in the destination will no longer be updated as there is no match in the Source sheet, and the Run Config will confirm that you have rows in the destination that don't match your Source:<\/p> What I would personally do in this instance is add a helper column in my destination sheet that does a quick check into your Source sheet. For example:<\/p> =COUNTIF({Unique Column Source Sheet}, [Unique Column]@row)<\/p> Then if this formula returns 0 (the current row does not have a matching value in the source sheet), you can set up a couple of automations based on this helper column... for example Conditional Formatting<\/a>, or exclude those rows from your Report<\/a>, or a daily automation <\/a>to move those rows<\/a> to an Archive sheet. <\/p> Cheers!<\/p> Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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":73615,"type":"question","name":"Data loss with Salesforce Connector","excerpt":"I am experiencing data loss with the Salesforce Connector where the Workflow account is overwriting user submitted data with a null value. For the first incident, deleting the field from the workflow, deleting the column from the sheet, and re-adding the field to the workflow seemed to stop the erratic behavior. However we…","snippet":"I am experiencing data loss with the Salesforce Connector where the Workflow account is overwriting user submitted data with a null value. For the first incident, deleting the…","categoryID":343,"dateInserted":"2020-12-02T16:12:25+00:00","dateUpdated":"2022-06-14T14:37:30+00:00","dateLastComment":"2023-10-24T16:06:45+00:00","insertUserID":48936,"insertUser":{"userID":48936,"name":"Gbur","url":"https:\/\/community.smartsheet.com\/profile\/Gbur","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-24T16:08:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":91566,"lastUserID":151863,"lastUser":{"userID":151863,"name":"Amy.Mizzi.RP","url":"https:\/\/community.smartsheet.com\/profile\/Amy.Mizzi.RP","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!--lodyZeIaI!WSnr3s4OMDI!xMBP55ynZXJ","dateLastActive":"2023-10-25T14:30:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":95,"score":null,"hot":3305093350,"url":"https:\/\/community.smartsheet.com\/discussion\/73615\/data-loss-with-salesforce-connector","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/73615\/data-loss-with-salesforce-connector","format":"Rich","lastPost":{"discussionID":73615,"commentID":401419,"name":"Re: Data loss with Salesforce Connector","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/401419#Comment_401419","dateInserted":"2023-10-24T16:06:45+00:00","insertUserID":151863,"insertUser":{"userID":151863,"name":"Amy.Mizzi.RP","url":"https:\/\/community.smartsheet.com\/profile\/Amy.Mizzi.RP","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!--lodyZeIaI!WSnr3s4OMDI!xMBP55ynZXJ","dateLastActive":"2023-10-25T14:30:06+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-12-20T15:12:04+00:00","dateAnswered":"2020-12-15T23:09:03+00:00","acceptedAnswers":[{"commentID":272000,"body":"
<\/p><\/img><\/a>\n <\/div>\n<\/div>\n
