-
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.
-
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…
-
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",…
-
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)…
-
Column level permissions
Since there aren't column level permissions, I tried Dynamic view, which would work great if we could utilize proofing with Dynamic View, which is not possible. I have columns a specific group of users should NOT be able to edit on my sheet. However , I utilize proofs. Does anyone have a creative solution to not allow the…
-
Help with a weekly updated formula
Hello! I'm still a beginner smartsheets user, and while I am decent with excel the live updates is still very new. I'm trying to create a formula that will pull information on a weekly basis, M-F, that updated for each week and didn't pull from the previous week at all. For example in this screenshot, I would like a…
-
COUNTIFS formula error
I am trying to calculate training sessions based on 2 columns : status column and year column. I've done this numerous times before however for some reason no matter what status filter I choose the outcome is 0 when there are definitely values for 2024 completed training sessions. This is the formula I am using =…