-
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,…
-
Using COUNTIFS
Hi All, Newbie posting. Been using smartsheet for my projects and keen to delve more into the reporting side for Board information. I have a Smartsheet that I use to record installs of certain types of products, we have three different types. I have used a formula to count the number of each type of product with an example…
-
Active turn around times by status of a row
I was wondering if theres a way/formula to track the amount of time a line stays in a certain status. For example - If we are using a line to track the life cycle of a contract we would have a created date field and a contract status field. The status field would consist of fields like "Contract Review" "Legal Review" "On…
-
Get the 1st value of Children
Hi, I would like to get the 1st value of children. Please see example below.
-
Conditional Copy from Sheet A to Sheet B
Hi everyone - have looked through the forums for items like "conditional cell linking" (which would be awesome), but cannot find what i am looking for; not sure if this is possible, super complex, or something very basic/simple that i am glossing over. Essentially, i am trying to move data entered in "tableA" to "tableB"…