-
CC Myself on all Alerts
Is there a way to CC my team mailbox on all outbound alerts that result from a form submission?
-
Count Checks on Another Sheet
I need a formula that matches a user's name on the first sheet and goes to a second sheet to find that same user's name and counts how many times that user has a checkbox checked off. I tried something like this but am getting #NO MATCH as a result. =INDEX(({Target Sheet with Username Column Selected}), MATCH([Username…
-
Negative Values corrupting integrity of Symbol Display Formulas
I've got a sheet that is setup with a "Synergy Savings Risk" column with a formula to show the red/yellow/green status based on the "Synergy $ Performance %" which is a formula comparing "Synergy/Dis-Synergy Actual $" column with "Synergy/Dis-Synergy Target $". I have a problem in that when the "Synergy/Dis-Synergy Actual…
-
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,…
-
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…
