-
COUNTIFS: Column Formula pulling from 2 Columns on 2 Sheets
Hello! I've built some COUNTIFS in the past and I've always struggled, but I've also always managed to get it in the end. I'm trying to build a column formula that pulls data from 4 different columns between two different sheets. What I've come up with so far is coming back with UNPARSEABLE. =COUNTIFS({Reviewer 1},…
-
COUNTIFS Formula with Multiple Criteria
Hi, I'm trying to figure out a formula to count volunteer hours (Monthly Meeting Hours) by a certain location (Organization Location, "Fairmont Area") for specified timeframe (Quarter, "Qtr 1"). I can get it to work without adding the hours in my dashboard but when I try to add hours get a error . Can you help?…
-
Retrieving one specific text/number
Hi, I'm looking to retrieve a specific text i.e. first warranty, second warrant, third warranty, initial order, labor only. I'm using a countifs formula but I need to count any line which only has the word "warranty" in it. Would I have to use a FIND formula? Thanks
-
SUMIFS with an either or condition
I'm struggling to make this work . . . . I'm starting with a SUMIFS that works: =SUMIFS({5_METRICS_SALES LEADS Current Year Goal}, {5_METRICS_SALES LEADS Today}, YEAR(@cell) = YEAR(Today@row), {5_METRICS_SALES LEADS Sales Lead}, VARIABLE@row) The 5_METRICS_SALES LEADS has two columns I want to sum (Current Year Goal and…
-
Check Box If "Due Date" is in the Past and Keep Box Unchecked If Not
Hello, I am wanting to use a simple formula that will check a box if the "due date" column is in the past while also keeping it uncheck if the date has not past. I am assuming I will use the IF formula, but not sure how to write this. Thank you, Ryan Holguin
-
How do I verify if text in one column has a match in the text of another column?
I have two very lengthy columns of names on one sheet. How can I determine which names appear on both columns and which solely appear on the left (longer) column? I really need to know where there are matches and where there aren't. I know this might be simplistic, but I'm fairly new to Smartsheet. Thanks for any help.
-
Countif a value is within a range of Owner Names
=COUNTIFS(Owner:Owner, INDEX({eRNP team Range 1}, MATCH(Owner:Owner, {eRNP team Range 1}, 0)), Status:Status, "5. Closed - not")
-
Sheet Summary Formula using cell populated by Index/Match - #NO MATCH
Attempting to use Sheet Summary to total all "Lab" Products shipped in "2022-08." The Product Type (Lab) in the Product column is pulled in using Index/Match. When I enter the formula below, using info pulled in by Index/Match, I receive the #NO MATCH" error. =COUNTIFS(SHIP:SHIP, "2022-08", Product:Product, "Lab") - #NO…
-
How to visually show "capacity" on dashboard
What I would like to do is have a "max" line or threshold, say of 100, so someone can look at the graph to see the capacity each project mgr has.... What is the best way to do this in Smartsheet on a dashboard?
-
Secondary email tagged in a conversation - who gets notified?
Hi, I'm thinking of adding a secondary email to my account but I see in link below that notifications only go to the primary email address- Change the Email Addresses Used with Your Smartsheet Account Does that mean that when the secondary email is tagged in a conservation - only the primary email will get notified?