-
Resource Management
If multiple resources are assigned to a Task, and the % Allocated is different for each resource, I assume that the only way that this can be correctly recorded in Smartsheet, is to duplicate the Task a number of times so that each Resource has his/her own line? What will then be the impact on Duration - if the Task has a…
-
Project stage and date in the Future
Hello Smartsheet super formula humans! I need some assistance! We are trying to create a formula where a checkbox is checked if the project meets the below criteria. Recurring On hold Pending approval + In Progress with a Go-Live date of after 3/31/21 The Recurring is its own checkbox without a formula, the On Hold,…
-
Return to Work Templates
Has Smartsheet created or does anyone have any locally successful templates for helping to plan out Return to Work from a manning perspective? Specifically, our government office is working to have a max capacity (20-30%) of total workforce in the office at any one time, and trying to create a published schedule that…
-
Update Request Results showing data that was deleted from Update Req. Form
I am sending an Update Request (UR) form to employees to have them tell me how many hours they worked each day. The smartsheet is prefilled with 8 hours each day. So when the UR form get to the employee, they just make adjustments as needed. In the image below, the employee received the UR form. Deleted 8 from the Hours…
-
Not so pretty IF-function (works) but needs makeover
Keeping track on vacation time I need to convert dates to weeks and then again to an overview with checkboxes. In order to get a list of weeks [c_weeks_listed] (later in use with FIND) I have come up with the following IF-formula which works but will become too complex if expanded further. Any ideas for a more powerful…
-
Sort by Parent Values Without Changing Order of Children Rows
I have multiple tasks each with multiple sub-tasks. The tasks and sub-tasks are not in alpha order, for example: Whether I leave the rows expanded or collapsed, when I sort the rows by task, it sorts the task and the sub-tasks, like so: However, now the sub-tasks are out of their correct logical order, e.g., analyze data…
-
Send a notification to an email address submitted in form.
Hello, I am currently using SmartSheets for our staffing agencies to submit potential candidates to open requisitions. On our side of smartsheet, we have a drop down with the "status" of the candidate (Pending, submitted to hiring manager, rejected, hired, etc) that helps us process submissions. When an agency submits a…
-
How do I find a smartsheet expert for hire to help build out our workspace?
Hello all, I am looking for a smartsheet expert, who can build a project template for us, including a dashboard for internal and external use. We are based in The Netherlands, but we can manage everything in English as well. So are you / or do you know an English speaking smartsheet expert, who we can hire for support and…
-
Can i remove multi-select from single cell?
Hi folks, Bit of a novice here, i have a challenge for you 😁 We use smartsheet for tracking holiday, sick leave, unpaid leave etc. For 2019/20 we've only had a single-select option for each cell, but this makes it difficult to track when employees work 1/2 a day and also 1/2-day Holiday or 1/2 day unpaid, on the same day.…
-
Request Time Off Tracker Help
Hello, My story seems to be familiar to others, but no past post seems to have a good solution. I've been searching the community forums here for a request time off tracker template (found a couple none actually worked), ended up creating my own. I got the majority of the automation and formulas worked out but I'm stuck on…
