-
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".…
-
Clarification Using AVG() with COLLECT()
I am looking to understand how the COLLECT() function nested within the AVG() function works and is evaluated. Using the help files, I found the following example. I am specifically looking at the very last formula where the result is "60". I understand this example completely. However, when I look at the example shown on…
-
COUNTIF to determine the occurrence of "specific text" from another sheet.
I've been able to find close approximations to what I'm looking for, but have one missing piece. I have a summary sheet ("summary") that pulls data from another source form evaluation sheet ("source"). Essentially, I have a workflow in place on the summary that when stakeholders are identified for a specific client an…