-
Automation 'When a row are added' does not work when a column 'is blank' is selected
Here is a simple Smartsheet automation - When rows are added and 'Status' is blank, change the status to 'Open'. It does not trigger on addition of a row where 'Status' is blank. If I run it manually it works. If I select any other value instead of blank, it triggers and works. I have been struggling with this automation…
-
Guest access set to Edit, but cannot attach files to sheet.
I have a vendor that is helping our company with a deployment. We have given their PM access to our sheet as Edit cannot share, but when they try to add attachments to the sheet it comes up stating they do not have access to upload to that line. Why?
-
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…
-
Concatenate with a Date
I am sure the answer to this is simple, but I just cannot get it. Here is my current formula: =[TO - Project]@row + " - " + [Deliverable Number]@row + " - " + OY@row + " - " + [Date Submitted]@row Now the Date Submitted field displays as MM/DD/YY, however I need it to display as MM-DD-YY I have tried a few things, but all…
-
ADA Accessibility Design in sheets
We have a Smartsheet accessibility concern. We have employees with vision disabilities, for whom the gridlines are difficult to distinguish between cells, and the gridlines literally vanish when using some cell background fill colors, such as grey or brown. We have attempted to use conditional formatting and alternating…
-
Bridge workflow - add multiple rows with one api call
I have an incoming sheet (sheet 1) that gets entries through a userform and it allows users to request up to 5 items per form submission. Each item goes into its own column (Column1 through Column5). Then I have a bridge workflow that is triggered when a new row is added to sheet 1. This workflow creates a new row for each…
-
WorkApps Administration - Creator/owner ONLY
How can I have others in my team edit a workApp that I am owner of?
-
Are there resources that can support with making custom dashboards?
I work in real estate and I want to build a custom dashboard/template to track where we are at with deals. The pre-made templates are all too specific and hard to use. I've created my own sheet/intake form but am looking for support on building the dashboard and how information is shown.
-
Prevent Duplicate Copy Row
It would be helpful to have a feature that prevents duplicate rows when using the “Copy Row” option. Sometimes rows get copied multiple times by mistake, causing duplicate data. Adding a check to avoid duplicates would improve data accuracy and reduce manual cleanup.
-
Skip WBS vs. Deleting Task
Is it best to Skip WBS or actually delete the task? Are there benefits to either?