Formula Help Needed
SummaryFormula Help Needed
I have a situation where I need to write a formula and I am not sure how to most effectively/accurately accommodate this need.
Scenario: I have 4 dates, across a group of submissions. I need to look at date 3, if that doesn't exist, use date 2, if that doesn't exist, use date 1. Then need to find the difference between that result and date 4. And now average that for the group of submissions. I need to do this for multiple times and have one neat row of result columns.
Any ideas would be appreciated!