Can two date columns feed the same calculated column depending on which one is answered?

I have a date column that is prepopulated based on a connection to another sheet of current employees. From this, I have calculated the number of days since an event. If these employees are no longer in my connected sheet, this date becomes a #No Match. I've created a second column of manual entry dates for these terminated employees. My goal is to get this second column to feed the same "# of days since the event". I've tried multiple 'If' statements but have not had any luck. Is there any way to feed this singular column depending on which of the two dates are populating?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!