-
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…
-
Creating SUMs based of a multi-select column for each selection.
I have a report that has a multi-select column with a variety of selections. I am trying to create cells at the bottom of that report that show the total #/SUM of each selection that are within that multi-select column. (Ex. I have a sheet that has column with you can select Active, Pending, Completed from a drop down. I…
-
SUMIFS Formula to calculate the sum between dates
Hey Smartsheet Community, I have a rather simple formula that is giving me trouble, I am just trying to get the sum of a revenue column between two dates. So far this is what I have and it is coming back unparseable: =SUMIFS({start date}, >[Start Date]@row AND({end date} < [End Date]@row), {revenue}) Any help here would be…
-
Formula that will display the lowest value from two data sets (with the highest value).
Hello Smartsheet community, I need some help fixing a formula. The goal = Display the lowest value between (the highest value between 1A and 1B) and (the highest value between 2A and 2B). The formula I created is: =MIN(COLLECT(MAX(COLLECT([DATE 1A]@row, [DATE 1A]@row, @cell <> ""), COLLECT([DATE 1B]@row, [DATE 1B]@row,…