-
Can multiple form entries populate one row?
Use case: A team lead submits a form reporting a start time for a delay in work, giving information about the delay and crew members involved. Later, the team lead submits another form reporting the end time of the same delay. Is it possible to have multiple entries populate the same row so the team lead doesn't have to…
-
Start/Finish Date Updates based on Status - Gantt Charts
I have a Gantt Chart that my company uses to track a multi-step process. In this process, Step 2 cannot begin until Step 1 is completed, Step 3 cannot begin until Step 2 is complete, etc.. Each step normally takes 2 weeks (and this is what we have in the Duration column), but due to the number of moving pieces it can…
-
Backing up sheets
Hi all, quick question. How do you backup a worksheet? For example if something gets deleted in the attachments and I want to find it, I saw on the message boards that you can access it with a backup sheet....but how do back up a sheet? Thanks!
-
Can I add summary row information to a bar chart widget on a dashboard?
I have a bar chart widget on a dashboard that shows the total number of projects active in different categories. I've been asked to add the total number of projects active across all these categories to this chart. In the report the chart is pulling the data from, I have this total in a summary field, but I'm not finding a…
-
Production Schedule with Horizontal View
We currently utilize excel to map out production by week, per product I would like to utilize Smartsheet, below is a sample of data entered in a Smartsheet Worksheet/Grid. PO's may be for multiple quantities, same part number (haven't looked at grouping as child rows yet), or mulitiple part numbers on one PO. I can group…
-
Dropdown list column sorting
I'm working with a sheet that has an unrestricted dropdown list column that the sheet is sorted by. I've found that the column is sorted alphabetically first by the values that are in the dropdown list and then it starts over alphabetically with the values that are not added into the dropdown list. We don't want to add all…
-
PMO template set up
Hi team, I wanted to set up PMO template set up for my organization. But I am trying from scratch to set up a new project but it doesn't work. The step I follow is. Create a project in the project intake sheet from the project intake form. Copy the project id from the intake sheet and try to paste it to Project level…
-
Need support using wildcard & sumif function
Hello, I have a sheet that's I'm trying to use the sumif function in, but I'm trying to base the criteria on a wildcard. For reference this is a sample sheet I made, and the wild card formula works fine in excel. Essentially, I want to SUM the values in the "RoleValue" column for a specific condition in the Quarter…
-
Horizontal Axis
Hello, I am hoping that there is a way to rename the horizontal Axis with grids rather then having to keep making a metric longer and longer. This is where the information is being pulled from. But, when I create a dashboard you will see that it is not being labeled with the months. Making my metric sheet and this…
-
I would like to import an Excel Workbook with multiple tabs. These tabs are interlinked w/formula
I would like to import an Excel Workbook (which is a Project Repository) that has a Summary tab with each tab having individual project details. The Summary tab contains the formula that links it to those individual projects. I am new to SmartSheet. I am unable to have all these sheets imported and the formula get…