-
How do I create an IF formula with checkbox?
Hi there! I'm trying to create a formula using a checkbox and I'm really struggling. Using the parameters below, can anyone help me with the formula? Column 1 = Australian states/jurisdictions (SA, WA, etc) Column 2 = Complete column with checkbox PROBLEM: If Column 2 is checked in Row 1, I want Column 1 in Row 2 to…
-
Multiple, comma separated values in one cell
Hi I'd like to create a report which returns all rows that have a certain value in column 'Donors' - i.e. we have activities that are funded by one or multiple donors, and I'd like to return all activities that are funded by Donor X. Conference one - donor x, y, z Conference two - donor y, z Three - donor x And the report…
-
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…
