-
What is best method to map data and manage ongoing changes from one Smartsheet to another?
I have been using a workflow automation to move a certain rows of information from one Smartsheet to another. These workflows are super easy and useful, but not that flexible. The provided workflow automation requires the column headers match up exactly between the two sheets in order to populate accurately. Where this is…
-
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…