自动化内容数据

Suser1 · 02/12/23

Hi all, my first post on here

We use smartsheet in our business for data and daily workflow. We manage dozens of employees who are getting assigned to do offline tasks, (they are not using smart sheet), usually with a client. We use smartsheet to collaborate between the managers, and we have the data in the sheets, but I would really like to have an automated tool, a computerized system to keep track of who is getting assigned to which client at what time and for what task, and also to track whether each client is getting all of the services they need, in order to prevent overlap, see who is available and generally make the workflow more efficient.

We have the business plan. I would like to know if that's something that could be achieved through available smartsheet tools. Thanks in advance

Andrée Starå · 02/12/23

Hi@Suser1

I hope you're well and safe!

Welcome to the Community and the wonderful world of Smartsheet!

Yes, Smartsheet can absolutely be set up to work as described, and there are multiple ways to do it.

Have you explored the Solution Center? There are templates that can be excellent starting points.

//www.santa-greenland.com/marketplace

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå| Workflow Consultant / CEO @WORK BOLD

✅了我的帖子(s)help or answer your question 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!

Suser1 · 02/12/23

Hi @Suser1<\/a> <\/p>

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

Welcome to the Community and the wonderful world of Smartsheet!<\/p>

Yes, Smartsheet can absolutely be set up to work as described, and there are multiple ways to do it.<\/p>

Have you explored the Solution Center? There are templates that can be excellent starting points.<\/p>

\/\/www.santa-greenland.com\/marketplace<\/a><\/p>

Did that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic weekend!<\/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>","bodyRaw":"[{\"insert\":\"Hi \"},{\"insert\":{\"mention\":{\"name\":\"Suser1\",\"userID\":158198}}},{\"insert\":\" \\nI hope you're well and safe!\\nWelcome to the Community and the wonderful world of Smartsheet!\\nYes, Smartsheet can absolutely be set up to work as described, and there are multiple ways to do it.\\nHave you explored the Solution Center? There are templates that can be excellent starting points.\\n\"},{\"insert\":\"https:\\\/\\\/www.santa-greenland.com\\\/marketplace\",\"attributes\":{\"link\":\"https:\\\/\\\/www.santa-greenland.com\\\/marketplace\"}},{\"insert\":\"\\n\"},{\"insert\":\"Did that work\\\/help? \\nI hope that helps!\\nBe safe, and have a fantastic weekend!\\nBest,\\n\"},{\"attributes\":{\"bold\":true,\"link\":\"mailto:andree@workbold.com\"},\"insert\":\"Andrée Starå\"},{\"insert\":\" | Workflow Consultant \\\/ CEO @ \"},{\"attributes\":{\"bold\":true,\"link\":\"https:\\\/\\\/workbold.com\\\/\"},\"insert\":\"WORK BOLD\"},{\"insert\":\"\\n✅\"},{\"attributes\":{\"italic\":true},\"insert\":\"Did my post(s) help or answer your question or solve your problem? Please support the Community by \"},{\"attributes\":{\"italic\":true,\"bold\":true},\"insert\":\"marking it Insightful\\\/Vote Up, Awesome, or\\\/and as the accepted answer\"},{\"attributes\":{\"italic\":true},\"insert\":\". It will make it easier for others to find a solution or help to answer!\"},{\"insert\":\"\\n\"}]","format":"rich","dateInserted":"2023-02-12T09:59:14+00:00","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-26T00:32:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/361859#Comment_361859","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/361859#Comment_361859

Thanks so much for your reply.

I'm looking for a solution that the system should return an error when, for example, a worker gets assigned to a client for a time slot that is already serviced by another worker, or when the same worker gets assigned to different clients at the same time. As a newcomer, could you please direct me to the template best suited for that task? Thanks in advance

Ipshita · 02/13/23

@Suser1- Here is what I can suggest -

Try using any project schedule templates from the solution center and then use the column - Owner or Assigned to to enter the names/contact list for your workers/employees who get assigned to clients (in this case, that's your project) so where Name1 gets assigned to Client1 (which could be under another column that reads Projects) -

Here is an example template for you where, the last two columns are for your (workers) and (client) respectively.

https://app.smartsheet.com/sheets/f7M45g5FfJHvMJjgxg4GM4mgGXX6ppH9G44r7Hp1?view=grid

Hope this helps.

Cheers!

Suser1 · 02/14/23

@Suser1<\/a> - Here is what I can suggest -<\/p>

Try using any project schedule templates from the solution center and then use the column - Owner or Assigned to to enter the names\/contact list for your workers\/employees who get assigned to clients (in this case, that's your project) so where Name1 gets assigned to Client1 (which could be under another column that reads Projects) -<\/p>

Here is an example template for you where, the last two columns are for your (workers) and (client) respectively.<\/p>

https:\/\/app.smartsheet.com\/sheets\/f7M45g5FfJHvMJjgxg4GM4mgGXX6ppH9G44r7Hp1?view=grid<\/a><\/p>

Hope this helps. <\/p>

Cheers!<\/p>","bodyRaw":"[{\"insert\":{\"mention\":{\"name\":\"Suser1\",\"userID\":158198}}},{\"insert\":\" - Here is what I can suggest -\\nTry using any project schedule templates from the solution center and then use the column - Owner or Assigned to to enter the names\\\/contact list for your workers\\\/employees who get assigned to clients (in this case, that's your project) so where Name1 gets assigned to Client1 (which could be under another column that reads Projects) -\\nHere is an example template for you where, the last two columns are for your (workers) and (client) respectively.\\n\"},{\"insert\":\"https:\\\/\\\/app.smartsheet.com\\\/sheets\\\/f7M45g5FfJHvMJjgxg4GM4mgGXX6ppH9G44r7Hp1?view=grid\",\"attributes\":{\"link\":\"https:\\\/\\\/app.smartsheet.com\\\/sheets\\\/f7M45g5FfJHvMJjgxg4GM4mgGXX6ppH9G44r7Hp1?view=grid\"}},{\"insert\":\"\\n\"},{\"insert\":\"Hope this helps. \\nCheers!\\n\"}]","format":"rich","dateInserted":"2023-02-13T19:56:57+00:00","insertUser":{"userID":139776,"name":"Ipshita","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ipshita","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/F9QTGWYO7ON4\/n1235F4AIWZTU.JPG","dateLastActive":"2023-08-09T04:39:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/362055#Comment_362055","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/362055#Comment_362055

Thanks so much for your reply!

I can't access the template you linked to, but if I understand you correctly you are suggesting to make it as if the offline workers are indeed getting assigned to smartsheet 'projects' - like a place holder for the real world work that they do. Is that so?

I'm just wondering if they wouldn't all need to have their own (paid?) smartsheet account in our system for that to work?

另外,这里实际上是一个三维which is time, as the same client ('project') can get assigned to different workers on separate time slots, and the same worker can work on a couple of 'projects' in different times, so I'm not sure how to integrate the time variable in this solution.

Please let me know your thoughts. Thanks in advance

Suser1 · 02/16/23

Just bringing this up again, I wonder if there is a solution out there.

Thanks in advance

Ipshita · 02/16/23

Hi@Suser1,

Hope you're doing well. I found some helpful links for you that might work.

Check out the following templates and links.

Cheers,

Ipshita

https://help.smartsheet.com/articles/2482042-date-time-reference-guide

//www.santa-greenland.com/marketplace/us/template-sets/data-input-and-data-collection

Good morning Experts, <\/p>

I have a particular set of data that is tracking productivity with a time element reported as (hour<\/em>):(minutes<\/em>) AM <\/em>or PM<\/em><\/p>

I am gathering the data in a form using text\/number. Once in the sheet\/grid I cannot figure out If<\/em><\/strong> I can or how to<\/em><\/strong> auto populate the results for a single time element in my sheet summary to display on a dashboard. I believe it may be due to the nonnumerical characters of AM\/PM interfering with the functions I have tried initially. I did simply select the individual cell and that will display, but when the sheet is cleared and new data arrives the sheet summary displays an #UNPARSEABLE error siting #REF.<\/p>

Desired reports would include daily and an average time over a 30-day period. I'm sure I will run into more issues on my second sheet once I get there as well. Currently data is moved from primary location where the form gathers the data to a monthly sheet, then at the end of 30 days it is cataloged in a repository sheet. <\/p>

Is this the best way to set this up? What formula would best work for time elements in a single day, or the average time over 30 days? Should I simply remove the AM\/PM element of the data being collected?<\/p>

Thank you for your assistance!<\/p>

Katie<\/p>","bodyRaw":"[{\"insert\":\"Good morning Experts, \\nI have a particular set of data that is tracking productivity with a time element reported as (\"},{\"attributes\":{\"italic\":true},\"insert\":\"hour\"},{\"insert\":\"):(\"},{\"attributes\":{\"italic\":true},\"insert\":\"minutes\"},{\"insert\":\")\"},{\"attributes\":{\"italic\":true},\"insert\":\" AM \"},{\"insert\":\"or\"},{\"attributes\":{\"italic\":true},\"insert\":\" PM\"},{\"insert\":\"\\nI am gathering the data in a form using text\\\/number. Once in the sheet\\\/grid I cannot figure out \"},{\"attributes\":{\"italic\":true,\"bold\":true},\"insert\":\"If\"},{\"insert\":\" I can or \"},{\"attributes\":{\"italic\":true,\"bold\":true},\"insert\":\"how to\"},{\"insert\":\" auto populate the results for a single time element in my sheet summary to display on a dashboard. I believe it may be due to the nonnumerical characters of AM\\\/PM interfering with the functions I have tried initially. I did simply select the individual cell and that will display, but when the sheet is cleared and new data arrives the sheet summary displays an #UNPARSEABLE error siting #REF.\\nDesired reports would include daily and an average time over a 30-day period. I'm sure I will run into more issues on my second sheet once I get there as well. Currently data is moved from primary location where the form gathers the data to a monthly sheet, then at the end of 30 days it is cataloged in a repository sheet. \\nIs this the best way to set this up? What formula would best work for time elements in a single day, or the average time over 30 days? Should I simply remove the AM\\\/PM element of the data being collected?\\nThank you for your assistance!\\nKatie\\n\"}]","format":"rich","dateInserted":"2022-01-12T14:50:22+00:00","insertUser":{"userID":142997,"name":"Katie J","url":"https:\/\/community.smartsheet.com\/profile\/Katie%20J","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-01-20T21:31:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/86450\/how-to-capture-time-elements-from-a-form-and-display-on-a-dashboard","embedType":"quote","name":"How to capture time elements from a form and display on a dashboard."}"> https://community.smartsheet.com/discussion/86450/how-to-capture-time-elements-from-a-form-and-display-on-a-dashboard

自动化内容数据

Answers

Categories