-
INDEX MATCH showing #NO MATCH when there is one
I am trying to reference another sheet. The column I am trying to match is the Primary column that has hyperlinks and I am trying to match the display text. Here is my formula =INDEX({Project Intake Sheet Range 1}, MATCH(Links@row, {Project Intake Sheet Range 5}, 0)) Range 1 is the primary column for the display text of…
-
Conditional Drop-down lists based on another column or field
I am looking to create a conditional drop-down list for a column based off the value in another column. For instance I have a column called Type (Product, Customer, Technology, etc...). Each Type will have its own Categories... Product (Print, Digital, Service) Customer (Private, Public, Government) Technology (HMTL, PHP,…
-
Conditional Drop-Down lists?
Is there a way to create a conditional drop-down list without using a form, and only using a sheet? We do not have the license level to create a data table. Example: Product selected from first list (one column): Internet Access Internet Access type selected from second drop-down list (second column): Fiber Dedicated,…
-
Cell range and Sheet Summary
I have an expense 'tracker'. Essentially it tracks if employees submitted their expenses (1) correct the first time; (2) expense was sent back for revision; (3) submitted late (4) did not submit My columns across top are months of the year. My rows are employee names. I have a sheet summary that totals (1), (2), (3) and…
-
How do I dynamically update a dropdown list?
I want to create a multi-select dropdown list with all future dates and this will be sent out in a form. Currently, smartsheet only offers a date selector with one max date. I was wondering, is there a way to upload values into a dropdown through an API? Otherwise, can I upload values into a dropdown from another sheet?…
-
extracting month from a date column and returning blank where no date
Hi, I am trying to extract the month from a date column and for cells without a date in the same column to return a blank. I have used the expression below but it returns an incorrect argument message. Can anyone help, please? =IFERROR(MONTH([Date CMI confirmation filed to matter]@row) = 1, "January", IF(MONTH([Date CMI…
-
Moving Rows to another sheet
Hello! I am looking for some assistance to see if this is possible. My company is utilizing SS for our staffs productivity. Currently it looks something like this in order for my formula in the "From Previous Month" to work staff must remain in the exact same order as it is not a column formula example for "Sally Sue" in…
-
Index(Collect with multiple criteria
I'm trying to make a formula in a sheet summary that checks if the "duration" column is not blank and then uses all rows that arent blank as a range to then find the row with the newest "created" date and return a value from a different "IndexKey" column. I'm not sure if i need to use an IF staement to limit the range or…
-
SUMIFS a number is within a range
Hi Community! I am trying to come up with a formula that will sum a column titled 'Hours/Week' based on if a specific person is 'Assigned To' the project and a number (the Week # being evaluated) is greater than or equal to and less than or equal to two other numbers (the project's Start and End Week numbers). This is the…
-
Parent RAG light Formula
I cannot get the syntax correct. I am looking for a formula where the parent row will show a green RAG light, if all of the children RAG lights are green, if any of the children RAG lights are red, then red, otherwise yellow. The children rag lights have their own formula driven off a date which works great. I just do not…