Unique Values for a CRM

Ask for Help Formulas
4

okay, I was successful in calculating Median TAT, Earned Revenue, and latest Order date. Please help me with OC date blank formula and Order ongoing formula.