-
Need help with using a COUNTIFS with OR
Hi, I'm trying to create a nested formula used in a ticketing system that will total up active status (Open or In Progress) compared to location. Ticket Active Status for Location = Location <and> Status [Open <or> In Progress] My Status column is using RYG balls, so "Red"=Open and "Yellow"=In Progress. I keep getting…
-
Ref SUMIF example in Help
Hi, Referring the SUMIF example in the Help article https://help.smartsheet.com/function/sumif, it is not clear to me why =SUMIF([Price Per Unit]1:[Price Per Unit]3, >20, [Transaction Total]1:[Transaction Total]3) has the result 3,115.00, and not 2,303.00, that is 1,491.00 + 812.00 Thank you, Elena
-
SUMIF for Contact Column Properties
My formula comes back as #No Match but when I filter, I see the results I need. I am hoping you can assist! I am trying to calculate the amount of time spent for a contact person. Here is the formula I have so far: =SUMIF([Contract Phase Assigned to]:[Contract Phase Assigned to], "Stephanie Bauder", [Total Time Spent…
-
RYG Ball Formula
Can you change formulas to make "Not Started" be the same as if it was blank? If I deleted the Not Started lines then my parent row would match my child/ children rows. (See snip # 2). I'm not sure if it's possible since you can't paste "Not Started" into a cell; it just changes to "Not Started". My current formula:…
-
Using CHILDREN for ranges in VLOOKUP or INDEX MATCH
Hoping someone can help with this as it seems possible... I have a sheet for contacts at individual centers across a state. There are roles assigned to the contacts, so for example there may be a director, a supervisor and a coordinator. In the sheet, each parent row is a row with general center information and (the part…
-
Counting # of Employees working this week
Hello, I am wanting to count the number of employees that are working this week. However my current formula does not take into account the number of unique names within a weeknumber. Any help would be apreciated.
-
SUMIFS function with Auto/Number system column
Hi all! I'm trying to summarize deliverables using the date stamp of when a form was submitted. Unfortunately the way our form is set up, we have employees fill out a form and enter the month and the year separately so our sheet does not have a normal date column. Is this possible to use the Auto/Number system column as a…
-
Formula comparing dates
I am very new to Smartsheet and the making of formula's overall so sorry for this question. I want to create a column where it will be highlighted when the date from column x is 4days or less apart from the date from column y. Does anybody know which formula to use? I started with this: =IF([column x]row number < Many…
-
Using COUNTIFS to count a single name in a multi select box in a date range
Hi all, This is my current formula, and it works except that if I have more than the name in the formula also checked in the multi select box it does not count it. How do I change this formula so it counts the name in the multi select box even if there are more than one name selected? =IF(COUNTIFS(Date:Date, <=Date@row,…
-
What am I doing wrong with this date function?
Hi all - I'm looking to build out a repeatable process calendar. We have something starting (Intake) on X day, and then a series of activities that take a certain amount of time. I'm looking to replicate the Excel function of (Date + X days). What am I doing wrong with this equation please? I keep getting "unparseable".…