-
What formulas should I use to count two criteria (including from a multiple dropdown option)?
I want to count "Enrolled" from "Case Status" AND "Medicaid" from "Insurance Type." I used the COUNTIF formula, but it seems like Smartsheet isn't counting the Medicaid cell if it's within a cell with multiple criterias selected. Screenshots below: You can see that even though 2 fit the criteria, the sheet summary only…
-
Calculate percentage of cells complying to one criteria
Hi, I need to calculate the percentage of cells within a certain time frame that comply to a certain criteria. More specifically, I need to calculate the % of complaints closed in the past 28 days (Date of closure = TODAY -28) that have a complaint investigation duration of less than 15 days. Please find an example of the…
-
Check Box with multiple criteria
Hello - I am trying to get a checked box: If Column A value = Column B value, check box. However, I am also getting checked boxes when A and B are both blank which should not happen. Current formula is: =IF(AND([TRACcess Serial Number as Per TRACcess Manager]@row = [TRACcess Serial Number As Reported by Tech]@row), 1, 0)…
-
Formula returning 0% instead of correct value in the sheet...
Not sure why my formula (using Index and Match) is returing 0% as a result of matching to another sheet? The correct data in the cell is = 55%. All other columns with same formula working correctly but one dept is showing an error o= 0%. Here is the formula =INDEX({Feb Score Column - BEAUTY}, MATCH(UII@row, {UII Store -…
-
Parent/Child Hierarchy Formulas
Hi, I have a formula to figure out where I want the parent rows to increase by 1 each time, while the child rows maintain the same number as the parent. IE only the parent rows should increase to match the numbering convention. I'm trying to get the A.X to match what's in the right most column (as those will be deleted and…
-
Calculating Time in HH:MM:SS
Hello, I'm hoping someone might be able to help me with calculating time in Smartsheet. We work with production teams in broadcasting, as well as other non-production teams, so calculating time is becoming rather vital, as more and more departments are using Smartsheet for a varying number of use cases: people and resource…
-
COUNTIF by MONTH in Sheet Summary Field
Hello, I'm trying to count the number of entries created in a month, based on the timestamp from the system generated Created field. I am able to do this with a helper column, where I perform the Month() function from the Created field in a column and then use the Countif formula in the Sheet Summary field (ex: To…
-
ISCONTACT function
Looking for the ability to create a nested if statement that evaluates certain criteria, however, because some of the criteria is a contact, there isn't currently a way to define a contact in Smartsheet apart from text. It would be great if we had a function that evaluates a cell as a contact.
-
Document Builder Customization
Hello, I am trying to use the Doc builder to populate a plant tag. This is thin and tall and we are tying to fit all the info onto it. Main question: Can I program the doc builder to turn text sideways so it can fit on the plant tag. See screenshot below I want the WHITE RNTZ to be turned to the side.
-
INDEX, MATCH, IF Formula
I am trying to pull a value from another sheet if the cell matches another cell and IF it is not checked off in the other sheet: If the ABV on sheet 1 matches the course in sheet 2, I'd like to pull the "EPM" from sheet 2 into sheet 1, but ONLY if the "Archived" column on sheet 2 is not checked.... (I want EPM on sheet 1…
