-
Check box if child row contain value of parent row
Hi, I have trouble figuring out a formula that will check the box of the parent row if child row contains the value of parent row. And the formula must work if it's a column formula. Thank you in advance!
-
IF Formula % Complete to Status
Hello - I need some help. I think I am close but my formula isn't working. This is what I'm trying to accomplish: ------------------- % Complete => Project Status Blank = Not started less than 100% = In progress 100% = Complete ----------------- =IF(ISBLANK([% Complete]@row), "Not Started", IF([% Complete]@row) < 1, "In…
-
Possible Solutions, anyone?
Hi Smarties, One of the users I am working with right now would like to have the following built in Smartsheet. Request Intake sheet > requester to enter the Task Type, Date Submitted and desired date for completion, and I will build a formula to estimate start date and estimate end date. I have managed to build a formula…
-
Determine if a Date is equal to or greater than 3 months ago
Looking for syntax help. I have columns (This Month, Last Month and Previous Month) to support some dashboard reporting IF statements. I am now looking to add a column called ">=3months" and I am unsure of the syntax. The syntax below is what I am using to determine Last Month: =IF(AND(MONTH([Record Date]@row) =…
-
SUMIFS & Specific Text/Quarter Requirement
I am trying to write a formula for a dashboard that sums the amount of money we spend a quarter based on a specific text. This is what I have so far and I'm getting "Invalid Operation". =SUMIFS{Log Sheet Range 2}, {Log Sheet Range 1}, CONTAINS("Pens", @cell), AND(({Log Sheet Range 7} = "Q2"))) Log Sheet Range 2 is the…
-
IF OR Formula
Can I get help with this formula? I need the answer to be 4 if either of these two columns are a yes. If both are a no, then I need the answer to be 0. If one is yes and one is no, then the answer still needs to be 4. =IF(OR([Innovate Audit]@row = "Yes", 4), ([Innovate Audit Included in Upgrade?]@row = "Yes", 4), 0)
-
Issues with autogenerated Asset #'s
I am autogenerating an Asset # that combines a Product code with a number. Here is the formula I'm currently using (thanks to Community members who helped last year) and a screenshot of some sample data. =IF(COUNT(ANCESTORS([Deliverables and Tasks]@row)) = 2, (Product@row) + 10 + COUNT(DISTINCT([Asset #]$1:[Asset #]6)),…
-
I am trying to add 5 years to a date
I am using the following formula =DATE(YEAR([Activation Date]@row) + 5, MONTH([Activation Date]@row), DAY([Activation Date]@row)) The Activation Date column is set to a Date column Type The receiving column (Expiration Date) is also set to a Date column Type I am getting an error #UNPARSEABLE
-
Index match or collect
HI Experts, I try to set up a formula for below table. Blue Part is on another sheet, and I would like to show the correct awbif article is the same and "Name" is "Kerstin" in the yellow marked column "awb new sheet". I tried a few versions with Index and Match or collect, but without success. Would be great if you could…
-
Count if (Advanced) Contact Field
I am having trouble counting the number of contact or lack of in two different instances. Count Assigned to Business Count non-blank contacts (exclude those that contain the word "business") First Metric: I would like to count the number of times my contact field has the word "Business" in it. I've tried the formula below…