-
Calculate % complete with Date Range and Today's date
Hello community, I need a formula to return % Complete based on a start - end date range and today's date. So for example: Date Range: 06/18/23 - 06/30/23 Today's date: 06/26/23 As there are 12days in this date range, and today's date is day 8 out of 12, the percentage complete would be 66.6% Thanks in advance!
-
Check box selection - referring multiple sheets
I have multiple sheets(sheet1,sheet2,sheet3,sheet4,sheet5) with email id's and I want to cross check in one master sheet in one check box column, if the match found then it should check the checkbox. can we use index match formula to refer multiple sheets? I'm trying to delete the master sheet email address if any of the…
-
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
