From what I read this is still not an option with Smartsheet. I would also like to have multiple date ranges within the same row. I would like to be able to look at a project (start to finish) but also like to see Section A, Section B, and Section C date ranges within that project on the same gantt chart row. I currently…
I have 6 columns in my Smartsheet that are date columns, two of which are start and end dates. I have got the start and end dates to appear in a calendar report, but the other ones (individual dates, not date ranges) do not show up. I cannot have them as children rows. I have tried applying conditional formatting to the…
I want to filter out these parameters - A project has 'New Store Unchecked' and 'Survey Scope Unchecked' The problem is that when a project has New Store Checked it will always have Survey Scope unchecked so I cant filter by 'Survey Scope Checked' as 'or' in the filter because I need to see those New Stores. Is there…
Hello, We are trying to create a vehicle reservation form, we currently have 3 vehicles. Objective: A user submits a form to reserve one of the three vehicles. They select a date range. Click on all day or duration if it's half day. The administrator of the vehicles will then get the request and determine what's available.…
I am running a report and when I do, the color of the progress bar in gantt view changes colors. One the individual sheet the bars and green, but they change to blue, orange, red, yellow, etc in the report. I cannot find any correlation to what colors they are changed to. Has anyone else seen/experienced this?
Working on a project with about 680 customers managed by 8 customer success managers. I need to track each customer's status throughout the project (will run through the year) with about 5 milestones. I'd also like to have a form so the CSMs can easily update the client's status after speaking with them, and a dashboard or…
I have a report that I'm trying to group by 'year' first and then by 'month'. The 'year' is sorted by 'Ascending' and the month is sorted by 'descending'. I'm trying to build a view where I will see the upcoming emails that we have scheduled to go out to students. For the ones scheduled in 2023, the report is working just…
I am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it. Thanks!
I have came across two request in our company to remove rows with grouping name like in the example below"Parent Workstream" to save space and make reports more clean on dashboards. Please consider adding a feature to hide that information on dashboards.
