-
Formula help - reference data from 2nd sheet, with conditions
Hi, I’m looking for help with a formula for my sheet. Images of my sheets are below Goal: I want to auto-populate the Holiday column in Sheet 1 with data from Sheet 2, based on certain conditions. Populate Sheet 1 Holiday column with data from Sheet 2 Holiday column, only if: Sheet 1 Date matches Sheet 2 Date, AND Sheet 2…
-
Count Cells that begin with a specific text
I wanted to COUNTIF the number of cells that start with specific four letters in a column of a reference sheet. I used the formula below and it returns zero. =COUNTIF({Reference Sheet}, "ABCD") Is there a formula to return the number of cells that have the first four letters as "ABCD"?
-
Using smartsheet-python-sdk to put data back into Smartsheet
I used the smartsheet-python-sdk (and unique API key from Smartsheet) to automatically pull data from Smartsheet into my Python script along with other data sources to create new feature-engineered columns. Is there an automatic way to now put these new columns I created back into the same Smartsheet I initially pulled…
-
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…
