-
Form did not populate a required field
I have a form and the first question is a required field. However, I have five entries (out of approximately 400) that have come into the sheet with no data for this required field. Has anyone seen this before? Any clue how this happened? Here's what I've checked: blank space is not an option (form won't let me submit)…
-
Reports - filter with parent rows
like you can in sheets, can you filter in reports and allow to automatic add the parent row. We use the reports to get more specific off our schedule. This is because you can use filter group in reports that you can't in sheets.
-
Schedule Baseline updates
Allow the update to baseline without using the start and finish columns. We are building out our schedule to be aggressive or realistic, but would like our baseline to be updated with dates that we choose. i.e. in our P6 schedule dates.
-
Sheet Filters in Filter Groups
Add Filter groups (and and or) in sheets as you can do in reports.
-
Seeing data in a report
Would someone need View permission to a worksheet in order to see the data presented in a report?
-
Lost all tasks in Gantt view
Today Mar-18, I've lost all my tasks in gantt view, but they are still visible in card view or grid view. Yesterday i've shared the sheet with the team with view only access. Did anyone have similar issues? and how to resolve this?
-
New Portfolio feature Question
We are using the new EAP feature called Portfolio to manage projects in Smartsheet. I want to try out some of the features in there such as report building across the entire portfolio, but I don't know where to access that feature. Specifically, I'm reading through the PDF documentation and on page 7 is shows that you can…
-
How Can I Combine Multiple Percentages Into One Cumulative Percentage?
I'm working on a project that has multiple components connected to the overall goal. To better know where we're at, I've created a done category to track progress in a percentage based on when a new box is checked. To accomplish this, I used the following formula: =ROUND(COUNTIF(Done3:Done8, 1) / (COUNTIFS(Done3:Done8, 0)…
-
I'd love to have a second row of headers
I don't even need them to be all that functional. Just be able to group Columns, allow me to open/close the entire group, and be able to use it in curly brackets to bring the entire group at once into a notification. Sorta like Parent rows, but for columns. It not only helps with speed of development, but also in the…
-
Edit recurring report email
I set up a report to get emailed to a few people once a month. I would like to edit who is receiving this report, but I can't find the report schedule. I found a few posts about this but clicking on File—>Send as Attachment just allows me to set up a new schedule. Can anyone help?