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
✅Did my post(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!
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
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.
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?
Also, There is actually a third dimension here 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
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
Andrée Starå ✭✭✭✭✭✭
Ipshita ✭✭✭✭✭✭![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/MD7ULWZVQF9R\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
