-
Adding IFERROR to another IF Statement
I am trying to add an IF ERROR statement to the formula below so that it is left blank instead of saying "#invalid data type". I'm struggling to make it work and would appreciate any help. =IF(MONTH([Launch Date]@row) <= 3, "Q1 ", IF(MONTH([Launch Date]@row) <= 6, "Q2 ", IF(MONTH([Launch Date]@row) <= 9, "Q3 ", "Q4 "))) +…
-
Distinct and Collect with Arrays
I am looking for the syntax for a COUNT, DISTINCT, COLLECT formula that will count number of distinct values in an array of cells, but only in rows that have a certain value in another column. For example: Active Status | Required1 | Required2 | Required3 A | PSY 101 | PSY 102 | ACC 233 I | BUS 212 | MHT 232 | ACC 314 A |…
-
COUNTIFS using current month
Hi all, I've been doing some searching on here and can't find the solution to my issue. I have a smartsheet which has four columns. Three of them may have a name (text/number), the fourth is date only. I'm trying to run a formula that detects the total count of name X from columns 1-3, in the current month. My formula is…
-
Using Index with Collect to Copy information from one sheet to another sheet for an entire column
Hello, I have 2 existing SmartSheets: Sheet 1: A Master sheet with 2 columns: Sheet 2: Another Sheet where only the "Die Name" where "Is Die 1 New?" = "true" is captured. I have tried the following formula under row 1 under "Unique Die Name" in the 2nd sheet: =INDEX(COLLECT({Die Name}, {Is Die 1 New?}, "true"), 1) This…
-
Can you create a formula for, 'If 'task name' is from another sheet, then insert flag symbol'?
I am looking to easily identify which tasks have been linked to a question sheet and added to the project plan.
-
Unparseable error with "IF"
Good day everyone, I'm having issues with the IF formula on Smartsheet. I tried to do it as I typically do it on excel but I think I'm missing something in here. Here's the formula that I'm using: The thing what I want to do is if the Growth is over 100%, I want the result ">100%" in the cell. If not, I want the result of…
-
How to Apply Filters in One Row that Adjusts Price in Another
I have a sheet that tells me the price of a product based on whether it's "Completion" is checked or not. I need to be able to filter the "Position" column to show me "Only Angle A" or "Only Angle B" etc. AND, I need the "Price" column to adjust appropriately when these filters are applied. The idea is that if we only want…
-
How do I use the SUMIFS function with the OR function?
I am trying to sum the total of amounts listed in column 1 if a specific name is in column2, or column3, or column4, or column5, or column6 AND the column7 ="won". Names can be listed in multiple columns in a single row. I want to avoid double counting an amount. I cannot seem to find a similar formula but I read it is…
-
Create a list from check marks in a grid
I need to pull data from a grid organized like this (with yellow items being being column headings): into a list that is structured like: I am stumped on how to do it. I do not own the original data so I cannot restructure it into a different form. Any tips? -Matthew
-
Index Match Formula Help
Newbie struggling with a formula. I have two sheets. In the main sheet the Intake Number is auto populated. In the second sheet, staff will input the Intake Number- the intake numbers may not be in consecutive order on this sheet as a result like they are on the main sheet. They will also provide notes on the case (column…
