-
Pareto smartsheet
The objective is to assemble a pareto indicating the highest value for the lowest value in the Smartsheet. Which is the best route? I see the attachment
-
Count rows based on 2 criteria?
Hello: I'm missing something here and I need your help. REQUIREMENT: - I need to have a formula that counts how many records on my sheet are both "LOW" (on the Priority Column) and "Closed" (On the Status Column) I've tried with COUNTIF, COUNTIFS, AND, OR....and Can't figure it out. Any pointers anyone can give me?
-
Using SUMIFS formula with CONTAINS or HAS as Criterea
I'm trying to only add up budget line items from specific months and that do not contain the value "Total" in their account code. Here's the formula I have and just can't get right. After breaking it apart, I'm finding the CONTAINS part of the formula is what's incorrect. =SUMIFS({Budget Detail $}, {Budget Detail Acct…
-
Formula to check a parent checkbox when any child is complete & formula to complete a parent status
Hi, I need help on two formulas. Formula 1: I need the parent box to be checked any time a child task is checked. So when any of the child tasks on TestAccount are checked in "test needed", I want the TestAccount parent checkbox to be checked so I can then copy all checked parents and children to a new sheet. Formula 2: I…
-
Parent completed when any child is complete & parent completed when ALL children complete
Hello, I am looking for two formulas. I need a formula to check a parent checkbox when any child is also checked. I tried to use a nested descendants formula but I keep getting errors. When any TestAccount child is checked, I want the TestAccount Parent to be checked so I can then set up automation to copy the parent and…
-
Looking for help with a formula to reference another sheet and sum fields based on Division
To reference this sheet and sum only for each type of division. ex..HR, IT, Operations, etc..
-
Converting Excel Formula to Smartsheets
Hello, Could anyone help me converting this formula into a formula acceptable on Smartsheets please? =IF(H13="","",EDATE(H13,INDEX($P$2:$P$10,MATCH(G13,$O$2:$O$10,0)))+INDEX($Q$2:$Q$10,MATCH(G13,$O$2:$O$10,0))) I keep getting the #UNPARSEABLE error. TIA
-
formula to count multiple values in one column
Hello, I have a long column that contains over 1000 values and I want to count how many times the values appear. I tried to use the countif formula but it is not working as the values are sentences and there are over 85 different sentences, which makes it hard to capture each sentence in a formula. Could you please help me…
-
Formula for returning value based on whether a date is between two dates
=INDEX(COLLECT({Payroll End date Range 6}, {Payroll End date Range 5}, Test@row >= @cell, {Payroll End date Range 7}, Test@row <= @cell), 1) Result: #Circular Reference or =IFERROR(INDEX(COLLECT({Payroll End date Range 6}, {Payroll End date Range 5}, ISDATE(@cell), {Payroll End date Range 7}, ISDATE(@cell), {Payroll End…
-
Notifications sending too early
Is there a way to set the time the notifications send? Our associates are getting notifications at 2 and 3 in the morning.