-
Referencing Another Sheet - VLOOKUP vs INDEX vs ??
Hello, I need to populate a cell with a number that is in another sheet based on an independent UID found in a different column that will be on both sheets. Not sure which direction to go on this -- For each line form-generated line, D. needs to look at C., find/match the data to A., then populate D with B when: A.โฆ
-
Barcodes scanned into a webform not converting to a number automatically in the sheet!?
Hoping someone can help with this promptly as I haven't got an answer from my support ticket from the 19th. We have a grocery store and the floor team scan the barcode of the stock coming into the store into a form and select the qty and expiry date. This goes to a landing page which has a formula in several columns toโฆ
-
Successors formula (German setup)
Hello community, I'm trying the new successors formula in a German setup, but doesn't matter what I try I'm always ending up with an #UNPARSEABLE error. Neither the German (= JOIN(SUCCESSORS(Spalte@Zeile),",")), nor the English (= JOIN(SUCCESSORS(column@row),",")) version seems to work.
-
Formula to auto pupulate status column based on dates
Hello, I am trying to get the status column to populate based on date range. I have a Start and Finish date in each row and want it to do the following When Start date is < today, say "NOT STARTED" When Finish date is > today, say "COMPLETE" This third one is tricky - When Start date is < = today AND Finish date is > =โฆ
-
IFERROR Formula to Resolve #DIVIDE BY ZERO Error
Hello, I am familiar with how to use the IFERROR function but for some reason with the specific formula below I am continuing to receive the #DIVIDE BY ZERO error message. I hope I am just missing a small detail with this and it can be resolved. =IFERROR(INDEX({Global GREF Project Tracker Range 3}, MATCH([Buildingโฆ
-
Form Email to only show what was filled out
Lets say I have a form that has 200 questions on it. The person who is filling it out, only answers 50 of those questions and attaches some documents. The email alert that I get automatically shows me all 200 fields and i have to scroll to see which ones they answered vs they didnt. How can I make the email only send whatโฆ
-
Multi-Select Count Criteria
Hello, I want to count all Small projects where the Top 12 multi-select column has any value populated. The multi-select Top 12 column will have many blanks. =COUNTIFS({All Projects}, "Small", {Top 12}, OR(....) Thanks, Amy
-
Count multiple values in a single cell
Hello. I'm very new to Smartsheet and a complete novice with functions. I can get by with bountiful resources in this community. I can't seem to find any other instance of the question I have about contact column conditional formatting. I hope it's possible. Ultimately, I want to apply conditional formatting to a cell whenโฆ
-
Formula References Not Updating
I have a sheet that has been in use for three years. It is populated by intake forms. Nothing on the forms or the formulas/references has changed in these three years of use. We have not had any problems with the formulas working. All of a sudden, when new rows are inserted, the formulas/references have stopped workingโฆ
-
COUNTIF and Month
Hello, I cannot figure out what's wrong with the below. I receive an "Invalid Data Type" error. I'm counting a column of dates and the column is formatted for a date. =COUNTIFS({2022 Epic Finish Date}, MONTH(@cell) = 1) Thanks, Amy