-
VLOOKUP: How to make into a Column Formula?
Good afternoon! I have the following formulas that I need to convert to a Column formula, any ideas? =VLOOKUP([Assigned Tech]2, {Team List Range 1}, 2, false) =VLOOKUP([Model Number]1, {Master Parts List Range 1}, 2, false) Thanks! Ashley Pierce
-
Invalid Argument Set in IF statement
Hi, The formula below is aimed at returning the date of a process step based on the current process step. It returns an invalid argument set when the process step is 7) Released. I have no idea where to start to troubleshoot. Any ideas welcome! =IFERROR(IF([Request Status]@row = "5) On Hold", "On Hold", IF([Request…
-
Automate RYG Balls Based on Two Different Dates
I am trying to create a formula that looks at two different start dates to set the project status. It looks at the first start date to see how far out (TODAY) is from that date and looks to see if there is a date in the second start date. This is what I have so far: =IF(AND([Start Date]17 >= TODAY(+28), ISBLANK([Start…
-
Formula in Dropdown Column
I have a dropdown column in a sheet for Sales people. See attached. At the top of this sheet, I'd like to do summary formulas for tasks and the best way to do that is to use the dropdown column for the formula. However, when I do this, it gives me the error #contact expected. I've seen this done on examples, but I can't…
-
IF AND with check box and other criteria
I'm sure I'm just missing a comma or something silly that my brain is not catching, but can I get an assist on this one? Deducted from Purchase Price is a check box column Accepting Extention? is a text column I want to add the value from the Amount Due column if the check box is checked and if the cell in Accepting…
-
IF, AND, OR Formula
Hello, I am trying to write a formula to use the flag symbol to flag a row as urgent IF the location is "Real" AND Staffing Status symbol is "Yellow" OR "Red". I am having a hard time combining them all to have the correct syntax. This is what I have so far: =IF([Location Status]@row = "Real", AND([Staffing Status]@row =…
-
I'm Stumped - Need a Percent Average when applicable
I have tried a number of ways to get this to work, and my hunch is I'm needing a percent average from other percent averages (where some may be an iferror result that needs to be unaccounted for). Attached is an image of the work. I need the average percentage of projects on design schedule for those with projects in…
-
Formulas with reports
Hi, I've combined two sheets into a report and I was hoping to do a summary sheet with various sumif formulas based on the data in the report. When I build the formula, the report is not an option in the list. Please advise. Thank you!
-
Linking cells - more than 39 rows at a time.
I am trying to link cells from one SmartSheet to another SmartSheet, but every time I go to do this, it will only link 39 rows. My sheets are empty right now as I set this up. So when my data sheet gets information in the 40th row, it will not link to my other sheet. How can I get this to link more than 39 rows?
-
Conditional formatting
Hi there. I have a sheet that has very many columns, and I wanted to create conditional formatting rules. Apparently, smart sheet does not allow to do this for multiple columns all at once, so I wanted to ask if there could be an easier or more convenient way to achieve this without having to do one column at a time? Thank…