Formula Issues

Beth Faircloth
edited 12/09/19 in Smartsheet Basics

Hey all,

Wondering if you could help with an issue. I need to get an average (days) for a column, but referencing another column. For example, I have 2 options (Existing and New) in a drop down list in one column and in another column I have total days. I'm trying to get an average of days for each of the options. 



Capture 2.JPG