-
IF Statement
Hello! I was wondering if anyone could help get me started on carrying out what I think will be a very long IF/AND statement. See attachments - I've created a formula to read the department column and the output will be the employee that has been entered into the top grey section in the Assigned To column. My issue is that…
-
Using AND with IF to check two text fields
Hi All, I am trying to create a formula in a sheet that references a range from another sheet to work out IF 2 text conditions are true but not sure of the syntax. Can I get some help please with my attempt below; Range 1 is a single select drop down using text Range 2 is a single select drop down using numbers 0-10 I want…
-
Return Column Names AND values from row in a reference column
I'm trying to figure out how to return the columns and values found in them for any given row. I have approximately 200 unique columns that are populated from a web form if/when the column is relevant. individual rows track construction items completed. Each row identifies crew, date, job number, etc., and the remaining…
-
Formula Help, conditional formatting/If statement
I need a calculation to occur when criteria are met in another cell. For example, I want column D1 to reflect the following: if column A1 contains "Yes", I want the sheet to multiply column C1 by .10. If A1 contains, "No". I want either no action or a zero to be entered into D1. Any guidance would be appreciated!
-
Solution for spreadsheet VLookUp type function from another sheet to populate drop down?
I'm looking to populate a dropdown based on "VLookUp" values from another sheet. Is there a clever way to mimic a dynamic drop-down based on another sheet in Smartsheet?
-
CountIf Status Last 30 Days & Next 90 Days
Hello, I have a sheet that has a columns that include Status, Start Date & Finish Date. I need a countif formula that will pull back how many Completed (Status) have fallen within the last 30 days (Finish Date). I need a countif formula that will pull back how many Not Started (Status) will fall within the next the 90 days…
-
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…