-
Struggling with Formula. Not sure if using correct one.
I have 2 sheets. We'll call Sheet A "Roster" and Sheet B "Grading Sheet" Sheet A has columns for "Employee Number" and "Email Address" What I am trying to do is on Sheet B, have a column in which you can enter the employee number, it reference Sheet A and then it will automatically enter the email address associated with…
-
Help with #Unparseable Formulas
Hi Everyone! I am a new Smartsheet user and am having some issues creating formulas that are based off of multiple columns where those columns are set up as drop downs with multiple selections. My Formula: =SUMIFS({Deliverables}, {Work Type} HAS (@cell, Reprint), {Fiscal Quarter}, HAS (@cell, "Q1"), {Fiscal Year}, HAS…
-
Can I use a SUMIF formula to sum children rows?
Looking for help on writing a formula to be located in the Parent Row under the Forecast column Row 1 to sum children rows of all Salesperson except Mike. I manually entered a formula =Value2 + Value3 + Value 5 in the Parent Row (90% Closing) Forecast column Row 1 to get the sum total of $700,000 that I am looking for, but…
-
Counting the number of unique contacts in multi-select contact column for a specific date
I'm looking for a formula that would be able to count the number of unique contacts that are in a contact column that match a specific date. I have a multi-select contact column that has the names of people that are attending meetings throughout the week, and I want to be able to see how many unique attendees will be…
-
SUMIF for terms in multiple selection drop down
Hello. I am trying to assign pricing according to requested testing, where each test has a specific fee associated with it. This fee is redacted in the below screenshot, but is formated as 123.45. I am hoping to get the sum of the different values. What can I correct in my formula to achieve this? Thanks!
-
Can I use Index/Match and Left functions in one formula?
Hello, can someone help me with the left function within the index/match? This is what I tried but it always returns NO MATCH: =INDEX({Master Job SO}, MATCH(LEFT([Job Number]@row,5), {Master Job #}, 0)) I also tried creating a helper column, Job Prefix, using =LEFT([Job Number]@row, 5) and using that result in the SO…
-
INVALID COLUMN VALUE
I am trying to pull a due date based on a prior cell's value. Example: Column "Financials Due Date" has a value of 10 In Column "Partners Due Date" I input the following formula but receiving an error. I have the column set to Date. =DATE(YEAR(TODAY()), MONTH(TODAY()), [Financials Due Date]@row)
-
Sheet Summary Formula - All Completed Tasks in the last 30 days
Good morning, I am trying to add the total number of closed items within the last 30 days. I have used a lot of the suggested formulas in past posts, but it is still counting ALL completed tasks (72) instead of the tasks completed in the last 30 days (40). I'm not sure if it's because it's a sheet summary and not within…
-
Color Symbols Based on Number Ranges
Is it possible to have a red/yellow/green circle symbol appear in a column if the cells of another column meet a certain range criteria? For example, I want a green symbol to appear when a cell has a number between 0-45, yellow 46-75, and red 75+.
-
Compressing based on a column label different row data points in one cell
Hi all. I am trying to do a rather complex operation on Smartsheet, generally performed in programming. I have two different sheets: one for Departments and another one for teams. Both sheets can be linked through the interrelation they have, although the teams sheet have multiple times the department across rows (E-G:…
