Sheets
Discussion List
- 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. Pop…
- 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 the…
- 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 co…
- 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 howe…
- 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 …
- 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 wa…
- 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.
- 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 colu…
- 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, …
- 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 …
