-
IfError- should this work?
I Am trying to get an IfError formula to work and not having any luck. CAn anyone help? =IFERROR([Product Type]@row = "Hardware", [Actual Shipment Date]@row >TODAY(-12), [Backlog @ Bud]@row), " ") I want that if a row is hardware and the actual ship date is not within the last 12days it populates the cell with the value…
-
Sum Child Rows when "children" are a different column
I am sure this has been asked before, but I can't seem to figure out a solution that will work in my sheet. I am trying to sum the child rows of a specific column, but my formula isn't working. Can someone take a look at the screenshot and see if you can help? I need to add the individual expenses (in the Expense Total…
-
Concatenate Name if Preferred Name not blank
Hi, I am trying to create a formula where I can concatenate a person's name as "Smith, John" if they don't have a preferred name listed (if blank) and as "Smith, Jane (John)" if they do have a preferred name. My fields are Last Name, First Name, and Preferred Name. Can anyone help? Thanks so much!!!
-
COUNT(DISTINCT(COLLECT - Counting a value per employee
Hi, I'm trying to count how many values I have for certain people. I have two values that are assigned to the employees daily, for each day we have a value of either "Y" or "N". I want to count how many "Y" an employee has. I'm getting this information from a big database, to have it summarized in a small one. I've tried a…
-
How to autopopulate % Complete based off of other cells entry
Hello, I am trying to autopopulate % complete based off of other cells YES/NO entries in the sheet. I have 5 criteria to determine if we get to 100% Completion or not: Columns: Paperwork Received - YES (add 20%) NO (add 0%) Samples Received - - YES (add 20%) NO (add 0%) HPCL Received - YES (add 20%) NO (add 0%) Hold…
-
Status Ball change 30 days after start date
Hello! I am assisting a colleague with a smartsheet issue. She would like the status ball to become yellow when 30 days have past the RFT start date and red when 60 days have past the RFT start date. I can't seem to figure it out and I thought I'd see if anyone can help while I continue to try and figure this out. Thanks…
-
Index Match Formula
I am trying to use sheet cross-reference formulas to pull data from one sheet to another. I have a "Roster" Sheet that lists the names of new employees who have many different job codes. I want to only pull the Last Names, First names of employees that have specific job titles. How can I use the index match formula to pull…
-
Is there a formula to get the average of star ratings?
I have a column that is only star ratings. I am trying to the get the average rating of the entire column in a sheet summary field. I tried to just do the average formula for the column and got the #DIVIDE BY ZERO error. Is there a formula that can calculate the average without having to create a helper column to translate…
-
IF(IS BLANK) - Multiple yes no criteria
I am trying to find a way to have this function look at 4 different cells and if any of them are not blank, it want it it say, "yes." If they are all blank, i want it to say, "no." I guess I need 4 of these strung together with OR. But I can't make it work: =IF(ISBLANK([Outstanding Audit]@row), "No", "Yes")
-
Workflow and/or Formula for tallying daily asset inspection issues
We have daily asset inspections that are submitted via a form and I'd like to: Create a daily Workflow that will send only the assets that had an inspection issue on that date, as well as the issue description. (Columns are: Asset, inspection yes/no questions, and description of issue) . Rows are each date an asset…
