-
Need help writing a Nested IF, IF OR and IF AND Statements
I am trying to write the formula correctly, I have a couple different versions and neither are working. I can get the first 2 parts to work in this version, but the last part fails giving me INCORRECT ARGUMENT =IF(OR([Line of Business]@row = "Valuation", [Line of Business]@row = "Property Management"), "Final",…
-
How to I calculate percentage progress in sheet summary based on status?
How to I calculate percentage progress in sheet summary based on status?
-
IF formula doesn't work?
Hello, I am using an IF formula to generate numbers but it doesn't seem to work when i have numbers over 10,000 and it just spits the same number back out. See below: the formula I am use is: =IF([column 1]@row >= 6500, "6,500", [column 1]@row) so I'm trying to get it to say if column 1 is over 6,500 then only write 6,500…
-
Index across sheets
I am attempting a complex formula that will link two SmartSheets. (See below for screenshots) SPAR Review Testing: Uses a form to collect document submissions. This sheet has a submission date column. SPAR Reviewer People Matrix: A people matrix that is used as a schedule showing who is responsible for reviewing the…
-
I need to result the column's name when using a JOIN(COLLECT) or INDEX(MATCH) formula
Previously, Row 1 of my smartsheet contained the column's name. This way, I could write a JOIN(COLLECT) formula to return the column's name if certain conditions were met throughout the sheet for that row. That worked until we applied column formulas to some of the rows. Now Row 1 can't be the column's name because of the…
-
Sumifs formula and isblank?
I'm likely missing something simple. I need a sum where the referenced column is either not "No" or if it is blank. The not "no" is easy, it works fine. It's incorporating the isblank that is kicking me in the behind. =SUMIFS({FY24 Travel Plan - Department Master Total Cost}, {FY24 Travel Plan - Department Master Range…
-
IF CONTAINS Formula to return different text values in second column
Hi! I am looking for some help in creating a formula where if a certain word is found in one column, another word is returned in a second column. For example if "Head", "Nasal", or "Spine" is contained in the Procedure column, "Neuro" is returned in the Clinical Specialty column. I've tried different variations of this and…
-
simple COUNTIF Sheet Summery formula
need help with this simple formula for a sheet summary =COUNTIF([IEP Status], "NEW (not signed)", "Active", "Active (Needs Att.)") something is wrong with the formatting I want to count number rows that contain these specific drop down list values. I put the values in quotes but the parentheses from the drop down values…
-
Is there are "CHOOSE" function? Calculating quarter from dates
My manager and I have been trying to find a formula that would calculate the FY quarter based on the "Start Date". We haven't been able to use a lot of the formulas we found on the Community because our fiscal year starts in Feb. instead of Jan. We've found a couple of solutions that's working for us now, but it's really…
-
Using Index/Match to display multiple values in a cell
Hi there, I have two sheets and I am trying to use Index/Match to pull multiples values in a cell in Sheet 1, into another cell in Sheet 2. I'm using the following formula, but I'm only getting the first item in the Sheet 1 cell to display. Here's my formula: =INDEX({01 - Product Grouping}, MATCH([Product Name]@row, {01 -…
