-
Average Formula
Hello, I am trying to find the average number of days a person works on a specific type of file. In example: What is the average number of days it took Tom to complete type “A” files from the Intake Date to the RFA date? What is the average number of days it took Tom to complete type “B-Renewal” files from the Intake Date…
-
If cell A contains specific data, populate cell C with data from cell B
Hello Smartsheet Community! I hope that everyone is well and had a Happy Thanksgiving, for those of you in the States! I need some formula assistance for what I'm trying to accomplish. I have (3) columns: A - Veggie Type, B - Veggie Qty, C - Total Potato Qty If A - Veggie Type is "Potato", I want the C - Total Potato Qty…
-
Count Number of Cells that Contain Certain Text?
Hello, I am trying to count the number of cells that contain certain words, such as "NYSEG" or "RGE," when the cells may contain more than one of these words. I have tried using =COUNT(FIND("ConEd", [Utilities]:[Utilities])), but it always turns back a 1 (no matter how many cells actually contain "ConEd"). I am trying to…
-
Making Parent Rows Display the Lowest status of their Children Rows
Hey everyone, I'm looking to have my parent rows simply display the lowest status of their children rows. My statuses are Complete, In Progress, Not Started. Pretty basic but I keep having hang ups for some reason. I don't know if it's because some of my children rows have children of their own to break up the task into…
-
I am trying to get latest date from a column
I have a column name Conditions having values A,B,C. There is also a column with created date in it. I am using this formulae =MAX(COLLECT({date}, {conditions}, "B")) It gives 0 when column type is text\number empty if column type is date
-
Unparseable Error
I'm getting an error #UNPARSEABLE for the following conditional formula that sets Red, Yellow, Green, Blue symbols per combined conditions of [End Date]'s proximity to "TODAY" + Status Condition (Not Started, In Process, Complete): Formula:…
-
Tracking Date versions
Hi @Paul Newcome I have one problem statement. Please provide your idea/solution in the below example Problem Statement: We have columns set up to track the dates when version 1 is submitted, version 2 is submitted, version 3 is submitted…. Etc. We want a column that says “Two Week + Flag” in front of the columns tracking…
-
COUNTIFS and CONTAINS for at least one item in drop down
I have a name drop down and and am trying to count the number of times my name shows in the Leader dropdown (by itself or with others) and keep getting UNPARSEABLE. =COUNTIFS({CMK - Issue Type}, "Quick Hit", {Harvey Progress}, "<>Full", {Leader}, CONTAINS("Ingrid Larson"; @cell)) I'd appreciate any assistance, please.
-
IF function + TODAY + Harvey Balls.
Hello I had this formula =IF(AND([PM % Complete]@row = 1), "Green", IF(AND([PM % Complete]@row < 0.75, Finish@row = TODAY(+5)), "Yellow", IF(AND([PM % Complete]@row < 1, Finish@row = TODAY(+2)), "Red", "Green"))) Which was working all right, but now it's not working correctly, specially when the FINISH date has past the…
-
Formula to reference sheet only if blank and certain conditions met.
How can I reference another sheet for names? I have a grid for current positions, some are filled, and some are not. For those that are not filled, column "Employee name" is blank and for those that are filled, column "Employee Name" is not blank. I have another grid with vacant positions only and it notes candidates'…
