-
Dashboard not updating after Sheet changes
For a number of years, our team has been reliant on a PDF Dashboard to issue to our clients. Recently, we have noticed that after new data is input into a Sheet, the Dashboard no longer reflects these changes automatically. Our system is programmed to work in the following manner. (A three-step process -…
-
Managing Multiple Weekly Update Requests
Hi - Wondering if anyone here can help. Our IT organization has a master source sheet tracking all the project requests for the team. Requests are made through a Smartsheet form which inserts a row on the master source sheet. As part of the development request, the PMO send out weekly automated update request to each of…
-
Date stamping the latest comment?
Is it possible to include the date with each comment in the Latest Comment column?
-
Import from .mpp file not perfect?
Recently have been testing out functionality within Smartsheet to compare to other products that are very similar and there seems to be a critical issue with the import functionality from MS Project .mpp files. See below from the same .mpp file: PCH-36 should be a parent on the same level as ASC/OQR, the section is…
-
Index Collect value based on a date
I want to index a value if the "This Sheet Date" on my final result sheet is greater than "Date Value Effective" on my database sheet. Screenshots should help. I have a column showing the value that I want it to return. It's showing me the 2% because technically all of the "This Sheet Dates" are greater than the "Date…
-
Discrepancy in API document and response for Sheet Object
I noticed in the Sheet Object API document, https://smartsheet.redoc.ly/tag/sheetsObjects#section/Sheet-Object, the field is "proofs" object, while in the API response for the same for "Get Sheet" API, the field is a "proof" object. There is a difference in singular and plurality, Is this a discrepancy? Can you please help…
-
Is there a way to have data from one sheet auto update the start & finish date within a schedule?
I have built a schedule with proposed start/ finish dates (which are driving the Gantt) as well as a column for the actual start/ finish dates. I can link the actual columns to the data sheet where teammates are inputting their actuals, but those columns do not drive the Gantt chart to show if any lag has occurred. I am…
-
Sheet to include new column: Attachment Name
As suggested in Attachment File Name Inserted in a Cell — Smartsheet Community it would be useful to have the ability to create an # Auto Column that simply displays the name of the attachments included in the rows. We sometimes have to provide reports to Clients that include this information - manually inputting this…
-
Export to Excel to include reference to attachments
When a Sheet is currently exported to Excel, there is no reference to any attachments that may have resided in the Sheet. As a minimum, it would be good to have a column in the XLSX that displays the name of the attachments included in each row.
-
Move data from one sheet to another. Do column headers have to match?
We are importing data from another tool into smartsheet. I want to keep that sheet as the "original" and then move that data automatically to another sheet that we have been using for a year+. A few questions. To do this it appears the column headers have to be exact. Example. Sheet 1: Sales Rep Sheet 2: Sales-Rep If I…
