-
Using IF OR MATCH to Check for Value in Multiple Sheets
Hi, I am trying to write a formula that will take a value from the sheet the formula is in and check for that value in other sheets. If the value is found in at least one other sheet, the formula should return "Y". If it is not found, it should return "N". This is my current attempt, but this just returns "N" for…
-
Multiple Sequences Need to Be Complete/NA to Provide a Complete Value
Writing formulas is not a strong suite of mine - I've tried a few routes (IF OR AND) but I'm either running into invalid formulas or formulas that are not netting the right results. I am trying to write a formula where I'm looking for sequence values to be either Complete or N/A and based on those sequences being one of…
-
IF statement based on cells in same row
I have a sheet where every row requires two approvals before it's fully approved. What would the formula be to make this work? For example, approval column 1 is named "initial approval" and approval column 2 is named "COHS approval". Both cells are dropdowns with the options pending, approved, or denied. I want the first…
-
Gathering information from another sheet with an IF function
I am trying to gather information from another sheet and then (possibly) use an =IF statement to format another sheet, but I can't figure out the formula that I need to use. A little more information: I have one sheet with raw data on it. I'd like to use this data on another sheet to create a "yes" or "no" text return. So…
-
If Formula help
Hello, I am trying to write an IF formula for my smartsheet that adds the letter A, B, C or D or E to a column pending on a dollar amount listed in another column, but I cannot seem to get the ranges to work right and everything is listed as either A or B. Current base formula: =IF([Total Assets]@row >= 1000000, "A",…
-
Conditional Text
Hello! I am trying to figure out if I can do a sort of conditional text entry. For example, if I enter "St. Bernard" in a cell in column A, then the cell in same row of column B would auto-fill with the word "dog" but If I were to enter "Maine Coon" in a cell in column A, then the cell in Column B would auto-fill with the…
-
IF formula from Excel to Smartsheet
Hi, I currently have a spreadsheet in Excel I am moving to Smartsheet with an IF formula. Can someone help translate what this formula should be in Smartsheet? In Excel, the Current Widget Liabilities formula is: =IF((2023 Paid Widget Balance + 2024 Paid Widgets - Widgets Created in 2024) <0,0,(2023 Paid Widget Balance +…
-
How do you make IF and IF(AND statements work together
I am trying to populate a cell based on multiple date criteria. I am currently trying to use the below formula but I am getting an unparseable error =IF([Date Submitted]@row > DATE(2024, 9, 30), 25, ""), IF(AND([Date Submitted]@row > DATE(2023, 9, 30), [Date Submitted]@row < DATE(2024, 10, 1)), 24, "")
-
Return different value based on date
Hi, I'm trying to write a formula to return different values based on the reference date ([Next Calibration/PM Date]@row) compared to today's date. I want the equation to: If the cell is blank, return as "Pending", If the date is < = today, return as "Overdue", If the date is > today, return as "Current", If the date is…
-
Join Collect formula that excludes the current row from the results
I'm trying to create a formula that creates a list of duplicates in my sheets, I've gotten this formula to work but it's showing the original row within the list of duplicates. I tried adding an auto number column and including a condition that the list shouldn't include the current row. However, the addition of this to…
