or Explore Discussions

# Human Resources

## Discussion List

• Project stage and date in the Future
In Formulas and Functions
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 a…
Accepted
11 3
Answered ✓ 11 views 3 comments Most recent by Krista Coffman Formulas and Functions
In Staying on the Same Sheet
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 workfor…
Answered - Pending Review
133 2
Answered - Pending Review 133 views 2 comments Most recent by Andrée Starå Staying on the Same Sheet
• Update Request Results showing data that was deleted from Update Req. Form
In Formulas and Functions
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 neede…
Answered - Pending Review
33 3
Answered - Pending Review 33 views 3 comments Most recent by Paul Newcome Formulas and Functions
• Not so pretty IF-function (works) but needs makeover
In Formulas and Functions
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 wor…
Answered - Pending Review
11 3
Answered - Pending Review 11 views 3 comments Most recent by Paul Newcome Formulas and Functions
• Sort by Parent Values Without Changing Order of Children Rows
In Using Smartsheet
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…
771 7
771 views 7 comments Most recent by Hillary Valor Using Smartsheet
• Send a notification to an email address submitted in form.
In Using Smartsheet
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 hir…
2685 10
2.7K views 10 comments Most recent by chris Perry Using Smartsheet
• How do I find a smartsheet expert for hire to help build out our workspace?
In Using Smartsheet
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 / o…
Answered - Pending Review
99 2
Answered - Pending Review 99 views 2 comments Most recent by Mascha van Sikkelerus Using Smartsheet
• Can i remove multi-select from single cell?
In Formulas and Functions
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…
Answered - Pending Review
39 1
Answered - Pending Review 39 views 1 comment Most recent by jpagan03101416 Formulas and Functions
• Request Time Off Tracker Help
In Formulas and Functions
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…
320 2
320 views 2 comments Most recent by Tyler12345 Formulas and Functions
• Formula to return multiple contacts based on multi drop down options
In Formulas and Functions
Okay, I'm trying to write a formula to automatically populate a contact based off the information selected in a multi drop down. I have a separate sheet that lists the appropriate contact for each item (Sheet Name: HR Contact for Reminder…
Answered - Pending Review
198 1
Answered - Pending Review 198 views 1 comment Most recent by Paul Newcome Formulas and Functions