-
Date & Time
Hello- How do I add the date and time from start of task to end of task from this form? I need to measure the date and time from start to finish. I'm using the FORM. Thanks.
-
Search for Duplicate Names within Two Separate Sheets
Good Morning, I am trying to enter a formula that will give a show me when a duplicate name is enter into one or the other sheet I am working on. We will be entering names daily into each sheet and we need to quick way to find if we have entered the same name in twice. Please let me know what formula you think will be…
-
Need IF statement to return a value based on sum between two numbers
This is my "if" statement - where am I going wrong? I am trying to code each line based on a value to help drive other actions =IF([Total Sum]@row >= $50,000.00, VP, IF(AND([Total Sum]@row <= $2,000.00, [Total Sum]@row > $500.00), A, IF(AND([Total Sum]@row <= $5,000.00, [Total Sum]@row > $2,000.01), SA, IF(AND([Total…
-
If(and( question
hi, i'm trying to get a formula to work but there's a few different factors that determine which value should be returned. 4- development tiers 5- stage gates an auto date based on when stage gate changes right now i have this that is returning back "unparseable" =IF(AND([Development Tier]@row = "Version Change/Iterative…
-
calculate networkday and exclude holiday
Hi all, I am trying to use formula to calculate the manufacturing dates between 2 dates for a factory that located a country and exclude holidays only when this country has these holidays, holiday list is in another sheet. How can I use networkday and IF formulas to achieve it? Thank you!
-
IF/COUNT and IF/SUM/CHILDREN Formula Help
I have a sheet (See below). In the 'Sheet Needed' column I have a formula: =IF(P@row = 1, COUNT([Sheet Created?]@row, IF(P@row = 0, SUM(CHILDREN())))) This is working in the Child Rows, however I am not getting a total in the Parent Rows. What am I doing wrong? I know it is late at night and I am sure I am doing something…
-
Health formula not working
I'm attempting to build a formula to change the health color based on a drop down of 3 options. My logic is this: If Flu level is less than 5%, turn flu risk level green. If Flu level is between 6% and 9%, turn flu risk level yellow. If Flu level is greater than 10%, turn flu risk level red The formula I came up with is…
-
Formula to return a value from a row range
I need help to define a formula that returns the value at a column x row intersect I modified a formula found in the community that returns the column header in row 1 but have not been able to determine how to convert that into a column reference to be used with @cell or @row to return the appropriate value. The formula is…
-
Need help with a Stacked If/Then Formular
I'm trying to determine if an applicant has qualifying income for the # in the Household. I have an income matrix by max and min qualifying income; by # of people in household. I'd like to create a formula that looks at the 'total # of people in Household' column and depending on the result, apply the correct max and min…
-
How can I add days to a date field within a logic formula to output a true/false value for a chkbox?
My objective is to create a new column where a box is checked once the row meets desired criteria. The checkbox will help me filter-out rows that will be synced via a Salesforce Connector workflow. The logic criteria is as follows: "Overall Status" = Blue (complete)….and…. "Working Launch" Date + 7 Days </= Today's date…
