I am struggling with this formula. My Syntax is correct, the lay of this formula works until I add my date range. I have tried having both my formula column and the referenced date column as date, dat…
I have tried to create the high level project sheet using linked cells and the index function however it keeps failing to transfer the information across. I need the sheets linked so that when informa…
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 t…
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 …
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 s…
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 s…
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 f…
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 M…
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 pret…