-
Formula returning unique values not working
Hi, I am using the following formula to return unique values in a spreadsheet. It works for other columns but not a specific column. =IFERROR(INDEX(DISTINCT({WDRS Core Build Log Range 3}), IDX@row), "") IDX is a helper column and this formula works for other columns. This specific column contains release numbers in the…
-
IF(CONTAINS) #UNPARSEABLE
Hello, I would like to return vendor details using VLOOKUP function looking up per vendor only if service contact is available. In addition, if there is no vendor found on the reference page, text "Add vendor to Vendor List" should appear. Tried this formula and received error message #UNPARSEABLE =IF(CONTAINS(“Yes”,…
-
Sheet summary to populate date in sheet
Hi all, I'm currently creating a template to monitor store closures and need some support in setting up a way to populate a date from the sheet summary. The end goal is to when in use, to be able to populate the date for the activity to start and able to flag any outstanding points after 30 days. We are able to populate…
-
Updating Status Based on RYGG symbols of Children Rows and RYGG Formula
New day, new formula conundrums! For these formulas, I'm looking to update the status of my PARENT rows (2 levels) based on the RYGG symbol as well as having the RYGG symbol is based the CHILDREN rows' Task Status column. I have both working but I feel like they could be cleaner and just wanted to get a second set of eyes…
-
Nested IF statement for multiple date range
Hello! I am currently attempting to write an all encompassing formula to read through different work windows. We are only able to work in certain areas of the city depending on the "work window". Depending on the work window, these dates have differing start and end dates. I can get one window to work properly, but the…
-
Average of the first 3 numbers and average of the 4th+ number
I'm trying to find the average of the first 3 months of data and then find the average of the 4th month and beyond of data. So for instance, the first row, the average of the red values and then the average of the green values. The start of data for every row could be different and the number total values of each row could…
-
Formula to assign a number based on criteria
Hi All, I am looking for some advice here. I work with patients who are being scanned for research. Each scan takes place at an imaging site. I have data that is automatically exported in via our API with our platform that records the orders for a scan. The sheet automatically copies rows based on date to a new sheet where…
-
Formatting currency with symblos
Hello, I am working on a smartsheet and need to know how to have to currency symbol automatically added based on the "Departure Country". I have two rows a Salary row and a Departure Country row. I need the Salary row to have the correct currency symbol based on the departure country which can be any country. PLease help…
-
Convert date format to "YYYY.MM.DD" in formula that combines date and text
Is there a way to do something like the excel formula =TEXT(TODAY(),"YYYY.MM.DD") in SmartSheet to allow a specific date format to appear in the output of a formula, regardless of the user's regional settings? All of our date columns have been set to the YYYY.MM.DD format, but we have formula columns that combine dates…
-
Formula Help
I need a formula that pulls the data from the column if that cell is not empty. (Ex; If 1 is empty but 2 is filled, pull data from field 2). As-Built Production Yield Final Production Yield 90% Production Yield 60% Production Yield 30% Production Yield Total Production Yield Target My current formula is below but it does…
