-
Quantity deduction workaround
I want to deduct the total "quantity requested" in the "final stock of inventory" after selected the "collected" check box and also wanted to show the available stock before confirming the order, Please help me with the workaround/ formula to achieve this Currently I use this formula, =[Initial Stock]@row -…
-
Check a box if values appear on two sheets
Hi, I'm trying to check a box if a Sales Force ID on my source sheet appears on another sheet This is the formula I'm using but am getting an "Invalid Operation" error. =IF({Sales Force ID} = SalesForceID@row, 1) Thanks!
-
Calculate Average Days When # is 0
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 subtraction. However, when I'm trying to get the average number of days it takes a lead to be actioned on by month I'm…
-
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…