-
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…
-
HAS Functions Returning 0
Hi Smartsheet Users, I am struggling with the formula HAS with multiple selection drop down values and hoping I could get some guidance here. Here, i would like to count how many "swimming" classes I have in a week. The expected result is 3. In the sheet summary, I have the formula written as…
-
#INVALID DATA TYPE - WORKDAY FORMULA
Hi, Can anyone please suggest why I may be getting #INVALID DATA TYPE error when using the formula shown below? I just can't seem to figure it out.... =WORKDAY(TODAY(), [SSI - Customer OH Days]@row)
-
Can I verify each entry in a multi-contact list exists in a different multi-contact list?
I use Dynamic View. Dynamic View, unfortunately, only allows 1 single column to be the list of users who can see data in a specific row. Smartsheet is not able to combine multi-contact lists into a single column that is recognized within Dynamic View. (I can combine multi-contact lists however, e-mail addresses listed in…
-
Help needed with averaging RYGB balls of children cells
Hi, I wanted to know how I can average the RYGB balls of the children cells. Something on the lines of if there is even 1 red, then turn the parent red. If there are no reds and at least one yellow then turn the parent yellow. If there are no reds and yellows, and at least one green, turn the parent green. If all the balls…
-
Auto-populate Cell after trigger
Hi Everyone, I am trying to auto-populate a cell with a date based on status "Sent to Client" (dropdown) being selected. I have this functionality already working with the formula: =(IF(Status@row = "Sent to Client", TODAY())). How do I replicate this action for a different date cell based off of a different status? I want…