-
Getting #UNPARSEABLE error
Hi all, I've four colums A, B, C, D. Objective is to A*B + C*D = total number. I'm getting an error. Not sure why? Highly appreciate if anyone can help. Attached is the error! Thanks.
-
Formula to separate address into 2 columns not working
I am attempting to use 2 formulas to separate an address that is comma deliminated, but the formula continually misses the mark. The formulas in use: Street address: =IFERROR(LEFT(Address@row, FIND(",", Address@row) - 1), "") City, State, Zip: =IFERROR(RIGHT(Address@row, FIND(",", Address@row) - 1), "") The Street address…
-
Auto numbering column
I am trying to do the same autogenerating reference numbers using a column that it is like the project class (What is it?) and the reference date will be the created column date that automatically assigned by system when the item is added. What i want in column Auto Ref Test that Generate the first Letter of "What is it?"…
-
Flag Parent Row if Child Task Meets Condition
I am looking for a way to count the children of a parent row, but only if the children have a particular attribute that is true. I'll then use that count to set up an CountIF to flag the parent row when the count is greater than one. The way my sheet is set up, I have parent rows and child rows. Milestone tasks are denoted…
-
I need help with the right "IF" or SUM IF formula
I want the formula to do a few things. 1 - Check to see if the row has CHILDREN and if it is a "Rollover PO" I have a helper column that is "CHECKED" if it is a parent I also have a column for "Rollover PO" 2 - If both are checked THEN I want the formula to SUM the CHILDREN in column [Total PO Spend] 3 - If the column…
-
Pivot Table Dates
I've created a pivot sheet using the Pivot App that includes a date of when a call was taken, however I'm having no success creating an actual date column from the column created by the Pivot App. Please see below for formula reference. Temp4 proves that Call Date, which is the primary column is not a date, which is…
-
Formula for Filter: Not in the last (x) days
Hi, What formula gives me the same value as the above filter? Would need something like COUNT IF {Range 1} Is Not in the last (x) days Thank you!
-
Max Collect Formula
I am trying to use max collect to display the latest step in a project plan based on the highest value in the "project phase" column that has been marked as green in the "Status" column. I am returning a vlaue of 0 no matter what I try to change here. any thoughts? thanks!
-
Need Help with Formula for Metrics
Hi, I am stumped at a formula for this sheet. Please see picture below. I am trying to calculate an action taken goal where we take the levels standard, urgent, and immediate and the action taken days. The parameter is for standard 3 days, urgent 1 day, and immediate 0 days. I want in the action taken goal column the words…
-
Calculating time elapsed date and time
Hi all, I've read a few solutions on how to do this but just can't get my head around to apply it to my own sheet. I have an incident register that we are moving into smartsheet and one of the columns is duration of outage. In excel we have two columns; Incident start date + time and Incident end date + time (format…