-
Add Custom, Pre-Set List of Update Request Dates
Smartsheet does not allow users to enter a list of unique dates for an Update Request to be sent out. The closest users can get to this feature is setting the Update Request to be sent on a certain day and time, however, this allows the user to enter only one date for one request (or a repeated sequence like daily, weekly,…
-
Multi-Project Gantt Chart with 1 Swimlane Per Project
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
-
"Save as new" with more than 100 items
Is there any way around the 100 item limit when using" save-as-new". I built a large reporting and dashboard structure with hundreds of individual reports and aggregate dashboards. The reporting structure is for a state agency that contracts with many partners, so lots of reports and dashboards for each individual partner.…
-
Automate when cell has contact added to remove all Pending Update Request for that row
When a form is filled out, and a row is added to my sheet, I have automation send to 3 recipients to update the "Owner" field. I want that Update Request to clear for all users and the whole row when an Owner/Contact has been added either through the button it sends/updates with or if anyone goes in and updates the…
-
Get Email from Contact Name
Formula or some option to get the email address associated with the Contact name. A name can be anything a user chooses (variable), but an email is not variable and can be used to do lookups more accurately than a name. (Relying on someone to type it in correctly is asking for trouble.) I currently use DataMesh to get the…
-
Counting only CHECKED checkboxes in report summaries
I several reports I've created I need to get an accurate count of checked checkboxes within the summary section of the report, and currently, the summary is counting all checkboxes- whether they are checked or not. The image below shows that it's counting 4 checkboxes, but it should only be three since that's the total…
-
Consolidated Work List by Assignee
One thing that I've found lacking in Smartsheet, compared to other products I've used, is a central location where a user can see everything that is assigned to them in one place. This would make it so much easier for our users to find what they need, quickly.
-
Access values stored in cell history
Hi guys, my idea here is to use the stored information in a cell value. Let's say that the first time this cell was changed is important to me and I want to store this value in a different column in my sheet. I would then use a formula to get this stored information, for example: =GETCELLHISTORY([info], [position]) info:…
-
Improve Load Times
Our consistent experience is that Smartsheet objects can take anywhere from 5-20 seconds to load. This feels extremely slow when you're actively facilitating a call and working between sheets, waiting for it to load. Other solutions in the industry have extremely fast, sub-5-second load times. I would request the product…
-
Cell-level Comments
Cell-level comments would be a huge time saver (similar to Excel) and in the Comments feature bar there could be a tab at the top that reads "Cell" next to the "Row," "Sheet," and "All" tabs. Currently, I'm spending a lot of time describing columns and going back and forth on communication to confirm columns and which…