-
Iterative Plan Template
There's an excel Iterative plan template posted on the Smartsheet site. Can a similar template be provided in Smartsheet?
-
Combine 2 sheets into one
I have 2 sheets, one with customer location data and one with parcel attributes. I would like one sheets that has the data from both sheets using the parcel number to match the information. (It is listed as Parcel # on one sheet and External System Link on the other sheet.) I am not even sure how to attempt this. Is it…
-
All cross sheet references randomly removed from sheet
Hey all, I have a weird issue. I have a sheet we use for our install calendar and randomly all the cross sheet references will be removed. This has only happened one time in November and again this Wednesday. I spoke with support and they said it might have to do with the automations but I'm not sure why the automations…
-
Dropdown list Default value
Hello, I have a dropdown list of 10 values, simply a Right First Time stat tracker. So they choose "yes" if the action on the line was done correctly, or choose one of the other 9 reasons on why it was not done correctly. Is there a way i can set the dropdown list to select "yes" as the default value? Thanks Andrew
-
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…