-
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…
-
How to Calculate Standard Deviation in a smartsheet?
Hi, I'm working on getting all metrics for a large project into a dashboard in smartsheets. I've been tracking a burn up chart in google sheets, but think that connecting directly to it doesn't look clean. So in an attempt to copy it over, I'm starting from scratch but can't seem to find how to do standard deviation as a…
-
Converting 2020-05-20T12:38:08.063 to a date format
Hi Everyone, I am using data uploader and importing an excel file that uses this date/time format 2020-05-20T12:38:08.063. Looking for suggestions on how to extract the date efficiently. At the point of export into excel there is no option to remove the time stamp so I'm kinda stuck there. Thanks in advance !
-
Auto fill information in sheet when a check box is checked in a different sheet?
Hi! I am trying to figure out how to auto fill information into my sheet, when I check a box in a different sheet. Essentially, all I want to do is autofill the check box on sheet 2 once it is checked on sheet 1. Is this possible?