-
Shared filter not working for other uses
Hi, I have created a shared filter on the Smartsheet sheet so that people can see certain projects only, and with the other projects being hidden. The filters hides the other projects on my sheet however it does not automatically hide them for other people. I have about 30 people using the sheet and it won't be practical…
-
Calendar View on a Report won't allow us to make comments
Hi, we have a Delivery Report which takes info in from approx. 50 Project Delivery sheets. If looking at the Report in Grid View we are able to add comments to all rows/sheets but when we are looking at it in Calendar View we aren't able to add comments to the vast majority of rows/sheets. There seems to be one sheet which…
-
How do I unshare individual sheets in a Workspace?
I need to share a workspace with some users with the exception of a few sheets that have confidential information. Is there a way to share everything except those sheets? There doesn't seem to be a way to do that without removing workspace access and then resharing every other sheet, report, dashboard, etc. manually. I'm…
-
Adding one word in front of selections in multi-select dropdown column
Anyone know of a formula that would do what I've manually done in the screenshot below? I'm trying to add one word in front of each multi-select option selected and put into a new column.
-
Is it possible to fill a column without Drag-Fill
Hey, I am new to smartsheet and hope you can help me with this: I want to write something in the top data field and then the text, number or date should be automatically copied to the rest of the column. I found this site: Create a Series of Numbers or Dates with Drag-Fill | Smartsheet Learning Center But the process there…
-
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…
-
Count and Distinct Formula returns 1
Hi, I'd like to retrieve the total values excluding duplicates, this is the formula used: =COUNT(DISTINCT([Part Number]:[Part Number])) ; using the count formula only returns the total value of 3535, which is correct considering duplicated cells, I thought it was due to an error in the data format or something similar, so…
-
What happens to my automation if I run out of rows?
Hey there! I am working with a large archival destination sheet: We haven't hit 20k rows YET, but it'll probably be coming this year. The automation moves Completed rows from an active tracking sheet to the archive sheet- we keep that for a full accounting of these completed processes. But.... what happens when…
-
Get Average of "checkboxes checked" for an entire column reference from another sheet
Hi Everyone - I'm trying to get an average of "checkboxes checked" for an entire column range. I came up below but it's not working. =COUNTIF({1 Main Speaker System Range 2}, 1 / COUNT({1 Main Speaker System Range 2})) I was successful to get an average of a row range because I divided by a fixed number. Here is the…
-
Max out Cross sheet reference ?
I have an error message "unable to create cross sheet reference because this sheet already contains the maximum number of different cross sheet references." How to resolve this issue? I already deleted many rows to reduce the cross reference but didn't work.