-
Linking to another sheet when a certain word is used
I am trying to get 2 sheets to work together. Meaning when I have a certain word or phrase I would like it to link to another sheet. How ever it can only be that word or phrase or nothing else. I need help Thank You
-
IF Statements and Linking Sheets by Ranges
Hi, I am working on a project creating a weekly sheet for distribution where one week of info is pulled from a range of data on a separate 13-week sheet. Basically, on the weekly sheet, I am using IF() statements to search a cell on the 13-week sheet for text. If the cell contains the proper text, the name from that row on…
-
Use a form to lookup sheet data that and add content to it
Hello, I have read the forms with the “VLOOKUP” and “LOOKUP” functions. I am new to smart sheet, but not to excel formulas. I have an associate inspecting carts for wear and tear items, this is working well with check boxes and the photo attachment is awesome to have. Next step is the associate that repairs the cart, I…
-
RYG Change Based on Moving Variable
Hi, all. I was looking to write a formula that would change a RYG based on if the project was still on track for the determined amount of time. It would start green and if the project was projecting as running longer than anticipated would change to yellow and then red when it went over a further threshold(of say %7 of the…
-
Index Match with some data returning as Invalid Data Type
I'm using an Index match to pull a certain number. In this column I will get a successful return of a few number then the Error then more correct numbers. Thing is, they are all pulling from the same data set (from an API), and using the same parameters and search values. Why am I getting the Invalid Data Type error?
-
Open-ended column on another sheet
I am using SUM referencing a column on another sheet and I want to get that column to be Open-Ended (so that when new rows are added to the other sheet, they will be automatically be in the new total on my sheet). Details: I am adding Hours from a time card sheet. When I stay on the that time-card sheet, Open-ended is easy…
-
Cell Reference Limitation
We're tracking different divisions within our company on separate sheets. We’ve created summary sheets that reference other smartsheet tabs and we’re consistently hitting the 100 distinct cross sheet references limit when building summary sheets. We figured out how to compile the information for each division via the…
-
Feature request: Cell Linking still linked when to you click 'Go to the Sheet'
So when your linking cells across sheets, I'm trying to link SheetX with SheetY (which has the attachments I need), I can link the site names between the sheet, when the preview screen pops up to show me SheetY (exactly where my site is linked) but I can't download the attachment from this preview screen, then when I click…
-
Copying rows w/ checkmarked cell to different sheet
Hello, I am trying to find a way to link rows between sheets, but the 2nd sheet should only show the rows from the 1st sheet with a checkmark in one of the columns. Sheet 1: list of skus with descriptions and details. One column has a checkmark for the critical skus Sheet 2: auto copy (i.e. link) only specific columns for…
-
Linking rows
Hi guys, I'm new to smartsheet and I'm trying to figure out it can help me become more productive. So far, I have always used excel. I am working with a lot of minute by minute schedules tailored to the needs of the different departments in my company. I have one large file displaying all the small activities that happen…
