-
Gantt Chart Showing Extra Years
Is there a way to define the end date for a Gantt chart that is displayed in a dashboard from a report? I'm displaying an annual schedule of projects using Years/Months as the headers, and the gantt chart shows blank space from 2022-2024. I'd like to display only the timeline for which there's content. Thanks, Brandon
-
Documentation edit requests
Curious if anyone out there has created something for team members to submit edits or changes for upcoming catalogs, technical manuals, product brochures. For example, we have a new Widget sized B, it needs to be added to the Catalog and to the Tech Manual. I want to create a tool all of our team can use so that proposed…
-
Sum in report in chart
Hi! I need to make a chart of two results. Collecting data from multiple sheets via a report. I include all the sheets needed, and then make groups for the two different items. As shown in the picture below, "Timer brukt" sums up to 602,5 and "Timer kalkulert" sums up to 1104,7. How can I get these two together in one…
-
IF formula for Days Past Due
New wrinkle to a previous issue. I now need to add more exclusion text to a formula. I want to show days past due if the text in the cell is NOT "Complete", "Excluded", or "Deferred". This is my current formula: =IF(Status7 <> "Complete", IF(TODAY() - [Due Date]7 >= 0, TODAY() - [Due Date]7)). How do I add the terms…
-
Separating rows in cells when generating pdf document
Is there a way to keep the rows clean and separate when you generate documents. In the cell I use "alt enter" to separate the information I type in. In the background, I have several formulas working to populate cells that allow me to print a pdf correctly. The information is correct, it's just one big long scrunched up…
-
How do I shorten the length of the text field in a metric widget?
I need to shorten these fields but can't seem to find how
-
Automate change of month on reports
I have a number of reports that calulate variously monthly totals that are used to feed into dashboards. I currently need to change the month it reports on manually every month - is there any way to automate this change? Garmon
-
What is the easiest way to achieve sheets with attachments?
Hello, We have sheets with attachments and would like to archive them for future use. Other than "retiring" them and moving them into a Smartsheet folder, or downloading all the attachments and putting them on a drive, is there a better way? What are the best practices for this? Thank you in advance! ER
-
Setting Default Values in Form
Is there a way to set up default values in a form? My boss receives the automation email will all of the info in it, and he adds the info needed. There are specific columns that 90% are the time are set to "No". Is there a way to auto-default those two columns to No but still be able to change them as needed? Thanks…
-
Smartsheet Limitation
Hi everyone, I understand Smartsheet have the following Limitations (plus many others). Can someone please clarify if the 10MB includes attachments ? The file cannot exceed 10 MB Up to 5,000 rows, 200 columns, or 200,000 cells can be imported at a time Thank you.
