Return If Not Blank Question

Hi! Overall I want to create a run chart with an average acceptance time over years. I think it might take more than 1 step, but am having trouble with the formula and not sure if it's even possible. Can you return a number when the cell is not blank along with another quantifier like year?

I was trying:

=IF(Elapsed Time]@row <> "", result, ''', (IRB Approval Date]@row, "2016")

Best Answers



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!