Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula to get averages from one column if another column is checked
I have 2 date columns, Processing Start Date & Processing Turnaround Time, then a column to show the NETWORKDAYS, (labeled Average Setup Time), of those two columns. Then I have a checkbox column (labeled New Setup)and another column to convert the checks into 1, 2, 3, etc.(labeled Setups).
What I need to do now is figure out the average NETWORKDAYS for those Setups converted to 1.
I have been fiddling with this on and on. Not too good with IF yet, but learning. I could give you a long list of the formulas I keep trying.
Screenshot attached. I may only have one column left available, so if there is any way to calculate this without adding another one, that would be great!
I should also mention that the averages will be in the parent rows, which are separated into months and then one average at the top for all months.
Thank you very much!