-
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…
-
Formula to return multiple contacts based on multi drop down options
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 Reminders). In the sheet "Seasonal, CDL, & Missing Requirements", I want the "HR Contacts for…
-
Vlookup Limitation?
Hi I would like to understand about this limitation in vlookup: * Each sheet can include no more than 100 distinct cross-sheet references. * There’s a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet in total.…
-
FIRST OF THE MONTH AFTER 60 DAYS
I am trying to auto populate effective dates for benefits and I cannot get the calculation to work past the first part (60 days after start date) I need to have the following result as an example Start date: 1/15/2020 Effective Date: 4/1/2020 Thanks!
-
Total Count for Specific Date Range from another Sheet
I am referencing a seperate SmartSheet that I have Admin rights on. I want to count the number of items listed within each specific date range was work by. I would like to then find out how many of those items have been completed. I have been trying to work with the following formula but it keeps bring back "0".…
-
Can the Sys Admin view the overall user activity in Center of Excellence for the assigned account?
As part of the Smartsheet roll out at our company, we 'assigned' our paid license employees several Center of Excellence Training Modules/Courses with different dates to get them completed. I am the Sys Admin and trying to verify who has completed their modules and who has not. Do I as the Sys Admin have access to view all…