-
Is it possible to enable gantt zoom function for a read-only summary report?
We are using a summary report to pull in key tasks from multiple timelines. The zoom buttons seem to be disabled and therefore we cannot change the period from weekly to quarterly etc. Is it possible to enable this despite it being a read-only report?
-
Automatically remove row in a sheet when cell value changed in the original sheet it was copied from
I have set up a workflow so that when a cell value (checkbox) is changed/checked in one sheet, that row is copied to another sheet. Is there a way to: Automatically remove the row in the sheet it was copied to, when the cell value (checkbox) in the sheet the row was copied from is changed back/unckecked? Thanks!
-
Display Select Few Rows from a Group
I have a report, in which I grouped according to project. Each project has several entries/rows showing updates for each project. On my Dashboard, I only want to show the first 4 entries for each project. Is there a way I can do this without relying on the date that the entry was entered?
-
Automatically capturing requestor's email address
Our business uses a form to capture requests of updates and changes needed to the business website. One field we have on the form is the Requestor Email Address. Currently, the requestor manually inputs their email and we've seen typos, etc. It would be great if since someone needed to "log into" their Smartsheet account…
-
How to show budget only for one out of several years budget plan?
Hi dear community, i build up a project plan, and its associated budget, wich is running over several years. Now, I would need to show the total budget per year (e.g. 2023) and i was using the following filter in my report. The problem i have is that some Work Packages are running over 2 or years and i'm not 100% sure how…
-
Form format option during usage
Hello ! Is there an option to format/edit text (such as bullets, bold, italics, hyperlinks) when typing into a smartsheet form? All inputs collected on this form goes directly on Dashboard, and we have so many format inside. I've reviewed the forums and help articles and haven't found anything that addresses this. Thank…
-
Multifactor authentication using DUO, how do we allow external users
I am not part of my organization's infrastructure group, so I don't have all of the information about this, but I want to ask the community's advice about this. We need to turn on SSO, and my engineer tells me that everyone who needs to access our objects will need to use SSO and that means that they need to be in our DUO…
-
Dashboard not allowing pie chart as a chart option
Hi, I am trying to get this into a pie chart to show total number of pieces of art in certain stages. It is visually more understandable as a pie chart and to also see the percentages in each stage. For some reason when I had to redo my report, it now won't let me select pie chart. Why is this? I have tried everything and…
-
Drop down options requiring additional data
I am building a root cause analysis database. My client area wants to be able to track the estimated financial impacts from a defect for which a root cause analysis is performed. The specific categories of financial impact are: $ parts, $ labor, $ misc, $ rental/loaner, $ opportunity. I created a drop down list for these…
-
Cell-linked dates don't go away when I delete the source
I have a sheet (The Milestone Sheet) that is made up mostly of cells linked to another sheet (The Schedule). The 'start date' column in the Milestone sheet is referencing the 'due date' column in the Schedule. I set the 'duration' column in the Milestone sheet to 0 for every row, which makes the due date the same as the…