Hello, I'm trying to create a formula where we track the days go from sent to actioned on. We have a column where it get's the number of days from sales sent to sales actioned on and that's simple a s…
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…
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. …
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 condit…
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. She…
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 of…
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 whe…
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 wha…
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 …
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 i…
