-
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…
-
Report Creation tool within a sheet
One of my most frequent uses of Smartsheet is as an editorial calendar for a weekly newsletter. I create a new sheet for every month of the year. Exiting a sheet and creating a report is not too much of a hassle but, it would be nice if I could click a button within a sheet that automatically opens a new page that is 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 =…