-
Setting up a Program with multiple project
Hello! I am fairly new to SmartSheet and am looking for some advice on how to set up a program management sheet. In short, I have multiple sites which have various tasks I need to track of. I would like to organize by site and task or at least be able to pull a report (or look at a dashboard) that will indicate what is…
-
Create a Drop-Down List from Another Smartsheet
Greetings! Does Smartsheet include a feature that allows for the creation of a drop-down in which the selection choices are pulled from a column in another Smartsheet? Thank you, John
-
One Data Set, Multiple Calendars
I have a sheet set up for publishing to Outlook calendar. "PTO Detail" is the primary column and displays on the calendar. I need to create a second calendar with all of the same dates with the second column "PTO Detail Team". What's the best way to go about this? All of the data is input via a form, and both calendars…
-
Counting dates not working
I have 2 sheets. A Master data sheet (sheet 1) and a 2023 blackout calendar(sheet 2). What I am trying to achieve is a formula that counts how many times a date has been scheduled in my master data sheet 1 [Installation Date], which matches/references the 2023 calendar in sheet 2 [Conversion Date], and bring the count into…
-
Visual indication of child rows when mouse hovers over the +/- icon of a parent task
Use case in mind: Working within a complex project plan containing lots of hierarchy. (Possibly with outdated and messy content...not all of us PM's are perfect =/) Having to open and close parent tasks often as you build out or make large structural updates to a plan. Opening and closing a parent task can be a bit…
-
Formula to copy contents of a sheet to another
I’m new to smartsheet and am trying to figure out a way to call contents of a sheet to another based on certain criteria, something similar to what Filter function does in google sheets. I am aware that I could achieve this using the index collect function, however the data I am trying to call goes in hundreds of rows. Any…
-
Allow Fuzzy Logic in Lookup Value Columns
Currently when typing in a lookup column, the list is only shortlisted to the first character(s) of the values in the drop down. It would be greatly improved to allow fuzzy logic as do forms when search via the drop down values for shortlisting. This feature should also be supported in Dynamic Views. Currently, Dynamic…
-
Is it possible to create bulk/multiple sheets using Create Sheet API in a single call?
Is it possible to create bulk/multiple sheets using Create Sheet API in a single call? FYI: I am aware of looping the request to create multiple sheets, but how can I perform bulk creation within a single call? Please help me with knowing how to achieve this. The response schema in the API documentation allows me to think…
-
Best way to assign many items to multiple people?
I have a Smartsheet with some 700 rows. Each row needs to be assigned to a set of individuals. I will be doing this monthly and it took ages to set up the first instance. I thought making groups would help but apparently not. How can I make these assignments most efficiently, please? And what is the point of Smartsheet…
-
Looking for a labor capacity tracking solution - SS Resource options won't work
Hello, I've seen a few people asking questions that lead me to believe I am not the only person looking for a labor tracking solution NOT at the day level. To use the resource tools in SS we would need people to estimate their workload on a daily basis with start and end dates. We want people estimating hours per week per…
