-
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 =…
-
FORM Links - same link moved to different sheet
It would be a great idea for tracking and traceability purposes in sheets, to have the kind of on and off button that allows the same form link to be associated with different sheets. Meaning that lets say i want to start a new sheet each year, but i want to keep the form link to be the same. This can be overpassed by the…
-
How to copy the latest comment in a row to a cell?
Hi all, I'm building a new sheet where we want to use the comments function, but I'd like to have a "read only" of the latest comment left by a user and with the time a date in a cell. This would help summarize the latest detail on a report or a first look at the sheet, and then if they want to check the history they can…