-
VLOOKUP with multiple reference sheets
Good afternoon! I attempted to use this template to create a multiple cross-sheet reference VLOOKUP. It works for the first three sheets but everything after the first three makes the formula unparseable. Any chance I can get some help? I have a handful more to add after this (a total of 36 sheets) but I wanted to try and…
-
=IFERROR(INDEX(DISTINCT) returning #UNPARSEABLE
Hi Smartsheet Community I have a rather complicated set up with this one. I have a source sheet with the following columns: [Full Name], [Month, KES Number], [Classroom], and a helper column ([Month]+[KES Number]+[Classroom]). I'm using the helper column to identify unique instances. On the target sheet, I have: [Full…
-
Metrics sheet not counting all values when using a column that allows multiple values per cell
-
Leading Zero for Day
Hello, I thought this would be simple, but apparently not, or I'm missing something. I'm trying to create a date key column using a date column. So a date like 01/02/2023 would read 20230102. My problem is getting the leading zero on the single digit months & days. The DAY & MONTH functions give me a 1 or 2, etc., when I'm…
-
Change a cell value workflow issue
When I use the Change a cell value action under Automations it always puts a ' in front of the value when in the sheet. Why is this? For example these are the results: If I put a number it comes out '7.0 If I put a formula it comes out '=SUM([Catherization Labs]@row:[Infection Control]@row) I don't know how to get rid of…
-
IFS formula and adding number of days
How to convert this Excel formula into Smartsheet =IFS(ISBLANK(C3),"",E3="Product1",C3+30,E3="Product2",C3+15, E3="Product3",C3+30,E3="Product4",C3+30) I would appreciate your help. Thank you:)
-
Getting "Invalid Operation" Error when trying to reference 2 sheets
Hi all, My first time posting in this forum! I'm trying to pull dates from 2 reference sheets (2021 and 2022 MCE sheets) into a target sheet using the IF function, as well as INDEX(COLLECT functions. The syntax seems right, but I'm getting an "Invalid Operation" error. I've confirmed that column properties for both the…
-
need help adding year to a SUMIF formula.
I have a cross sheet formula that sums activities based on "area" and displays in a dashboard. =SUMIFS({ITS Calendar rev3_WEEKS WEEKST}, {ITS Calendar rev3_WEEKS Activity}, ="Installation-Remisol", {ITS Calendar rev3_WEEKS Area}, ="West") This formula is currently working. I need this same calculation to perform based on…
-
formula help
Hello I have a check box to auto check to indicate next month however; I've run into an issue with January not checking and I believe it has to do with it being a new year. I found a formula that someone needed to look back from January to December and i tried to make it work for next month but it's not working. How can I…
-
Formula Issue
We are having trouble with the rows below the first indent. Here is the formula =INDEX({SCO-LO Int. Type-Gadget Group Lookup Range 1}, MATCH([LO Template]@row, {SCO-LO Int. Type-Gadget Group Lookup Range 2})) This is correct but once we get to the lower rows the gadget group it is pulling in is incorrect Here is a copy of…