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