-
How to include an if statement
I have a vlookup formula. =VLOOKUP([Attribute Name]@row, {Standards List - Enhanced - Business Rules Range 1}, 4, false) . I need to be able to use this formula and check another column based on the version number. I need it to pull in x if it matches the name and version number.
-
Combining AND with HAS and WEEKNUMBER
Hello Again, My goal is to have a formula that will do the following: If the Lot ID@row is found on the {Lot ID} column on an Archive sheet AND The WEEKNUMBER(Move Date) where the Lot ID on the Archive sheet was found is equal to Week#@row THEN give me a value. If not then 0. =IF(AND(HAS({Lot ID- Archive}, [Lot ID]@row)),…
-
Very simple IF formula
Hi, I’m trying to create a very simple IF formula, but keep getting back the #Unparseable error. I know that error is for syntax, so since it’s such a simple formula, I copy/pasted the formula from the IF FUNCTION section from Help & Learning and changed the name of the column and it worked. HOWEVER if I tried to change…
-
How to create children in large sheet automatically
Hi! I'm new to SmartSheet and not very good with Excel 😪. I have a sheet with over 18,000 rows that I would like to make any cell in the primary column with a date a parent of the rows beneath. I used an excel formula to find and add the date to the Primary column based on blank cells and a separate Event Date column (see…
-
SUMIF Formula Not Working for column with #'s but working with text..
My sumif formula is not working with a numeric value but it is working on a text value.. Here is my formula that is not working: Sheet Referencing: SAP WBSE is the same as Proj. Def. column. I'm asking it to return the Ovr Commit column, essentially 64,345.03 but it's returning 0 but when I sum it on the description column…
-
Pulling data from one sheet to another
I am currently in the process of creating a dashboard. I was originally planning to use cellular formulas to pull this data. The original formula I was using is: =COUNTIFS({JBO Type}, "Overhead", {Date}, IFERROR(MONTH(@cell), "") = 11) However, this formula is returning an improper total, it reads "24" when it should be…
-
Countif "Incorrect Argument Set"
I can't understand why this formula doesn't work... =COUNTIF([2022]1:[2022]11, [Deal Prob]1:[Deal Prob]11, "Green")
-
Get MAX date from 1 to many possible other dates that meet a criteria
I can't get my head around a solution for this formula, but I believe there's one in Smartsheet somewhere for it! Can you help? I want to put the MAX date into the Actual Implementation Due Date column from a choice of 1 to 4 dates. In this example, the formula should return 22-Nov-2021. Implementation Due contains a date,…
-
Formula to Indent blank cells in column
Is there a formula or existing function to indent only blank cells in a column? Thanks for any information! Best, John Stanik RN, BSN
-
VLOOKUP or INDEX,MATCH - how to deal with situation when source will change?
I have a MASTER contact list, which has every contact that we ever have. Primary key is email address. Then i have a template where a person picks a user from a Contact List and a bunch of columns get populated with phone, city, etc when the email address for the user is matched against the Master. So that template has…