-
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…
-
24 hour countdown
Does anyone know how to create a 24 hours countdown based on the created column? We need to trigger a notification or update request on a flag 24 hours after the row was created. We work in time zone globally and need to give the team 24 hours to complete their update request. Thank you in advance. Joe