-
How do I write a nested IF formula to count a location if 1 of 2 trigger answers appears in a field?
This is the formula I tried, but I'm missing something. =IF(OR[Location Status]@row = "Active", "Operational", 1, 0) Thank you for your help!
-
Find the Count of All Multi-Choice Answers
Hello all, I'm still a bit new to SmartSheet, so forgive me if I'm a bit ignorant here. I have a column that has several multi-choice options (Option A, B, C). I would like to know how many times, across all rows, each option was selected. The setup would look like this Row 1: Options A and B selected Row 2: Options A and…
-
Mimic a Pivot Table, Group by date and SUM
I'm trying to figure out how to essentially mimic a pivot table using functions. And no we won't be getting the pivot table app hence needing this solution. I want to group items from a sheet by matching dates in a column, and SUM the contents of a few other columns based on those matching dates. The SUMIFS is part of it I…
-
Health Formula - RGY
Looking for an assist with a formula. I want the parent health bubble to show the 'worst' status of any of its children. Basically: if a child's health is red, the parent's is red; if a child's health is yellow, the parent's is yellow, otherwise the parent's is green. Thanks!
-
Help with IF AND OR and CONTAINS in formula
I am trying to check a checkbox column if another check box column in the row is checked AND another column in the row contains either of two values. I can't figure out if I should use CONTAINS or OR and how to nest the IF. something like this..... IF (AND (checkbox1@row,1), IF(text@row contains "A" or "B"),1)
-
Sumif Month Formula
Hi I'm trying to find a formula that will sum up Hrs if a month is e.g. 6 - see screen shot below for the forumla I'm using but it's coming back with a blank, despite hours being calculated What am I doing wrong? TIA Cheryl
-
Is it possible to format numbers in K (thousands) or M (millions)?
Hi all, Is there a way to format numbers is thousands or millions to just K or M? Or any formula to do it? Kind regards, Grace
-
Creating a chart from non numeric values
I have created a form for users to fill out based on their experiences with a certain process. They will be asked questions such as "were instructions clear" and they can answer Very Clear, Somewhat Clear, Unclear. I was trying to create a pie chart from this sheet that shows how many users selected Very Clear vs. Somewhat…
-
Sales pipeline evolution metrics and dashboarding
I own a Smartsheet that captures all of the sales opportunities one per row and each marked with a pre-defined specific stage of the opportunity (investigation, qualification, archive, execution, etc). These will naturally evolve thru the sales funnel and individual smartsheet contributors will update the stage shortly…
-
Partial Match for a Vlookup
Hi All, I am looking for some help with a formula. I want to search for a particular value in a cell that may include multiple values i.e I want to locate A123 but the cell from the reference sheet contains A123; B456. My thought was to use a partial vlookup but from what I have read it does not look like wildcards can be…