-
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.
-
Vlookup a cell with a formula
Hello everyone, I am trying to use a normal Vlookup function in smartsheet. The search_value (number) and also the value that is supposed to be looked up in the look_up table (same number) are also pulled with other formulas. If I hardcode the numbers instead of suing a formula, then the Vlookup works. Does this mean that…
-
TotalFloat inconsistency between parent and child tasks
I am looking to utilize TotalFloat in a project plan and am finding inconsistent results with parent and children tasks. The sheet is set to Mon-Fri working days with no holidays set. The formula in use is =TOTALFLOAT([Task Name]@row) + " days" From what I am seeing: -The manually calculated delta between Line 14 and Line…
