-
Avg number of selections per condition
Hi there, I need some help. I'm trying to calculate the avg number of issues per condition in our master tracker. The issues are in a multi-value cell {Rev Rec Master Tracker Range 1} while the condition is a single-value cell in {Rev Rec Master Tracker Range 2} with values either as "Backlog" or "Net New". I'd like to…
-
Pull data from one sheet to another with same words
Hello, I am fairly new to SmartSheets - I am trying to figure out how to pull data from one sheet to another that would have a names in common. I.E. Sheet 1 has a course name of Smith AR Training. Sheet 2 has the Region Name as Smith in one column and then a contact person in the 2nd column. Because Smith is listed in both…
-
Can I turn off the "Used in formula on" information screen?
I have linked many sheets so now when I try and select a drop down within a cell I cannot because this "Used in formula on" window hovers over my select options. Is there a way that I can turn this off?
-
Elapsed Days Counter - How?
Hi everyone, I'm needing to report on elapsed days for a few tasks. Anyone know how to do this? Note - this is different from the 'duration' function that already exists in the Gannt view. That is where I have a start and end date. In this example, I have a start date, but no end date quite yet. Any help is greatly…
-
Count function
Hi I need help with a formula. I have a column that I want to count but only based on a values in a different column. I have tried the following formula but it's not working and I can't figure out what I am doing wrong. =countif([Test Script #]:[Test Script #], [Pass ?]:[Pass ?], <> "N/A") The Test Script # column is the…
-
Formula to collect the first and last values from children rows, but only if distinct.
Hello Community People, I'm working to create a report that will show a summary of the location where a person will be each day. The source sheet is set up with parent rows listing the date and child rows showing all the events scheduled for that date, and there is a single drop-down "Location" column to select the city in…
-
Sum range where relevant data may need to be first extracted from the cell
I have a series of columns where users enter number of samples tested each month. They can indicate the number of batches in the same column using a delimeter. E.g., 4(2) means 4 samples were tested in 2 batches. We cannot add a separate column to indicate batches. I want to sum the total number of samples across the range…
-
Nested "if" formula
I'm trying to convert this excel formula to Smartsheet but can't find the right procedure. Keeps coming back as unparseable. =IF(J3=100%,G3,IF(J3<100,"")) J3 will always be filled in with a % and G3 is a dollar amount. Any help is appreciated. Craig
-
IF/AND/BLANK Formula Logic
I'm trying to write a formula to reflect a progress % (using the bar symbol) based on three fields, where one field, if filled in, counts as 25%, the second field, if filled in, counts as 25%, and the third field, if filled in, counts as 50% (to equate to 100%). I'm using =IF(AND(NOT(ISBLANK, but I'm receiving errors. I…
-
Automatically Create Parent Row From Child/Children
What will be imported is the white (2,3 & 5,6,7) rows. I want a parent (ex: orange rows 1&4) to be auto-created for any unique number in the "Reference" field. Any help would be appreciated! Thank you!