-
Sheet Summary AverageIF
Good morning, I'm hoping someone can help me with this AverageIF formula. I am trying to get an average between two columns but only if the location in another column meets certain criteria, this is what i have but i'm getting #UNPARSEABLE =AVERAGEIF (Location:Location, ="Bonita",[Total Graded]:[Total Graded] [# Titles…
-
Calculating Average Days between 2 columns
Hi All! I am making a report for a Risk Submission Sheet and I have two columns within my sheet: "Date Submitted" and "Date Closed." I want to create a widget for a report that calculates the average days it takes to close a risk from the "Date Submitted" to the "Date Closed" for ALL submissions. Knowing that 1) risks…
-
How to create children in large sheet automatically
Hi! I'm new to SmartSheet and not very good with Excel 😪. I have a sheet with over 18,000 rows that I would like to make any cell in the primary column with a date a parent of the rows beneath. I used an excel formula to find and add the date to the Primary column based on blank cells and a separate Event Date column (see…
-
Formula to return a blank cell if columns are blank
Hello, I am working on a formula that will return me the following: If equal to or less than 4 = Low If equal to or less than 7 = Modest If equal or less than 11 = Moderate If Greater than 12 = High =IFERROR(IF([Risk Score (calculated)]@row <= 4, "Low", IF([Risk Score (calculated)]@row <= 7, "Modest", IF([Risk Score…
-
I'm trying to create an IF THEN formula showing that IF the check box is clicked for >250k
Hi, hoping someone can assist. [continuation from the above] then YES (Y). This interface is strange today, I wasn't able to add the dollar amount. Blah Thanks in advance.
-
Automatically adding info
I am trying to automate a monthly report that shows what staff member received work apparel. When someone received work apparel, they have to pay taxes on it. So I created a form for staff to fill out when they received the apparel. It has the Date Dispensed, Name, Description of the apparel and how many they took. With…
-
Formula Help
I am trying to write a formula that looks at a column in worksheet 1 and compares to a column in worksheet 2. If they match, populate another column in worksheet 1 with a different set of data shown in another column in worksheet 2. Help :)
-
SUMIF Formula Not Working for column with #'s but working with text..
My sumif formula is not working with a numeric value but it is working on a text value.. Here is my formula that is not working: Sheet Referencing: SAP WBSE is the same as Proj. Def. column. I'm asking it to return the Ovr Commit column, essentially 64,345.03 but it's returning 0 but when I sum it on the description column…
-
Alerts for max rows
Background: Shift information is typed into a main sheet in multiple columns/rows by multiple people, then at the end of the shift, the manager confirms the date, shift number, and shift information before checking a box that changes a value on each row, and triggers a couple copy to workflows. This is segmented into two…
-
Pulling data from one sheet to another
I am currently in the process of creating a dashboard. I was originally planning to use cellular formulas to pull this data. The original formula I was using is: =COUNTIFS({JBO Type}, "Overhead", {Date}, IFERROR(MONTH(@cell), "") = 11) However, this formula is returning an improper total, it reads "24" when it should be…
