-
Workflow - SAME SHEET copy a cell to another column
A workflow enhancement that is similar to the Change Cell Value. However, instead of changing a cell, copy it to another cell. Use case: I have a formula that calculates a date. However, I want to keep the initial value of the date and therefore, don't want to reference the date formula because it will change. A workflow…
-
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…
-
Include Project Name in Portfolio WorkApps Email Notifications
Hello Smartsheet Development Team, I’d like to suggest an improvement to the email notification feature when a new project is provisioned in Portfolio WorkApps. Currently, the email subject line only states: “You have been assigned to new projects in the [Program Portfolio Name].” It would be more helpful if the…
-
Control Center - Global Update for Conditional Formatting
We would love to have the capability to push new conditional formatting using global update for provisioned project sheets. We have over 200 projects and whenever we get new ask for new conditional formatting (since things change all the time), it's a huge manual hours to go through and update each provisioned project with…
-
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…
-
Attach File to Form to be Filled and Uploaded with Form Submission
I need to have an Excel file available to folx filling out a purchase request intake form I've created in Smartsheet. I need the Excel file to be accessed, filled out, uploaded to the form (via File Upload, that part is a no-brainer) and then submitted with the form submission. I see this type of request all over 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.
-
Activity Log should reflect all changes made to a sheet (in detail) including Workflows
As of today, the activity log doesn't represent all of the activities undertaken on the sheet. For example, if a row hierarchy or conditional formatting has changed, columns formatted/hidden/unhidden or removed, it won't show up on the activity log in detail. This is difficult when we are trying to investigate the root…
-
Dynamic Filter on Dashboards
I really miss allowing the user to actively filter information from their dashboard view. I wish I could have a filter button that could be positioned on the dashboard. Then the user could choose to see the data of a period or a project, for example.