-
Chat notifications directed to reports
Our ECR solution is based on intake sheets with relevant data being brought into different reports depending on the users role. We make use of the chat function within smartsheet to communicate, but the notifications always direct the user to the underlying sheet. It would be great if we could re-direct the users to the…
-
Formatting issue with my rowID field, anyone notice anything like this before?
I've used this same formula in a few sheets now. In the past it's looked like the first screenshot below. Using the same formula in any new sheet I create it's now putting the expected values for the second line on a third line below the "-", seen in the second screenshot. Here's my formula: =Account@row + "- " + [Story…
-
Merged: Apply conditional formatting to a range of Columns or Rows
This discussion has been merged.
-
Direct Email Approval Button for Smartsheet Automation Workflows
Integrate a direct approval button within the email notification itself that allows users to approve or reject requests without the need to transition to a web browser. This button would perform the same security checks and record the same audit trails as the current browser-based approval, ensuring that the process…
-
Sync columns across sheets
I created a workspace for requesting/approving/tracking projects. If a project request is declined I move it to another sheet. When I made the new sheet I copied the columns so initially things were sync'd. When a project moves to the declined sheet, any missing columns are added at the end (far right) so things stay…
-
From ESRI GIS to Smartsheet
I came across many articles regarding connection from Smartsheet to GIS, but I'm interested in getting attributes out of GIS and into Smartsheet. We have many program administrators need information from GIS and manipulate it to create and track projects.
-
Open to Today's Date when in Gantt view in the Mobile App
When a sheet's Gantt view is set to open today's date it it's settings; the settings do not apply to the Mobile App view. The settings should also take into account when looking at the sheet via the Mobile App.
-
How to set up an automation that is based on an if statement?
Hello! I am trying to set up an automation that changes a cell to "Complete - Pass" when four different conditions are meet. The way I am doing this is by adding and additional column that does a pretty complex if statement, and from that it either returns "Pass" or "Fail". =IF([QA Filter FAIL]@row = "Fail", "Fail",…
-
Sheet - Format Cell Border
The ability to format cell borders with line style and color.
-
Copy Rows Automation
Hello, I am setting up 2 sheets. One Master Sheet and the other - User Sheet. I am setting a copy row workflow automation so that every day at 5pm rows added to Master sheet are copied to the user sheet. Before i implement and test this, i am wondering: Will Smartsheet know to copy only rows added that day(masters sheet)…