-
Need help with syntax for IF(AND(OR nested statements for a risk assessment table
this is what I have, getting an unparseable error. I changed all the "" to straight quotes. trying to make the cell this formula is in, equal a risk rating as determined by the formula, the graphic matrix is below. HELP!! =IF((AND(OR(Probability@row = "low", Impact@row = "low"),OR(Impact@row = "med", Probability@row =…
-
How to sum up column RGY statuses?
Hi Smartsheeters! I am trying to sum up column RGY statuses. The formula that I use averages the sratus and I end up with either Green or Yellow. =IF(COUNTIF(CHILDREN(), "Green") = COUNT(CHILDREN()), "Green", IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", "Yellow")) Please help me figure out where the error is. I need to…
-
What's wrong with my formula?
=COUNTIFS(Position2:Position196, CONTAINS("Medical Assistant", @cell), [Cleared to Return?]2:[Cleared to Return?]136, OR(CONTAINS("No", @cell), CONTAINS("Contingent", @cell)))
-
Using Month/Year in formula
Am I missing an easy way to pull in a count based off month in a chart? For ex. My chart shows July and I would like my formula to count events based off the July name in the chart (@row), I could only figure this out using a month helper column in my source sheet and having to manually adjust each formula? If I used 07/20…
-
Distinct Count
Hello, I am going round and round trying to get a total distinct count from the ID Admits-Year column. I have tried formula. =COUNT(DISTINCT(COLLECT([ID ADMITS - Year]:[ID ADMITS - Year],)) and I am getting a number 1 when I have 2 ID's that show up multiple times. Let me give more background information, I made the helper…
-
SUMIFS and Contains
I'm trying to use SUMIF with CONTAINS using: =SUMIF([Payment Amount]2:[Payment Amount]3, CONTAINS("FY20", [Date Paid QFY]2:[Date Paid QFY]3), [Payment Amount]2:[Payment Amount]3) But I'm getting a 0 result. Note that Date Paid QFY is a formulated column that returns for example, Q1 FY20 based on another date column. Please…
-
if formula help
I am trying to do a formula that states: if there is text in the column2 then place a "1" in the primary column. @Paul Newcome
-
Multiple IF statements
Hi, I'm attemping to assign PRICE to items based on CONDITION and CATEGORY but my limited skills with formulas are keeping me from my desired results. I'm hoping some one can help me out. In my PRICE column if have the following formula. It works for the "Chair" category but nothing else. Any guidance is appreciated.…
-
#INVALID VALUE Error - Can't figure out why...
I am working with two sheets. "Payment Tracker" and "Job Tracker". Payment Tracker: Auto: Auto-Number Column - No formatting Row: =MATCH(Auto@row, Auto:Auto, 0) Invoice Number: Primary Column - Manual Entry Invoice Amount: Text/number column =INDEX({Job Tracker Invoice Amount}, MATCH([Invoice Number]@row, {Job Tracker…
-
How to extract date from date/time
May someone please assist? How do I extract the date from "1/15/2021 9:24:55 AM"?