-
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…
-
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…