Formulas in a Table with Dropdown List

Hello!

I have a table that gets auto-populated from a Microsoft Form with some data about defects. In the first column there is a formula =IF(TODAY()>[@[28 Day Deadline]],"Past SLA","Open"). I want this column to show 'Open' when the line gets auto-populated, or "Past SLA" if it's past a certain date, BUT there are also dropdown options that will be manually selected based on the status of the defect. Of course, once one of the dropdowns in selected, the formula is removed, meaning that it does not auto fill when a new row is added. Is there anyway around this?

Thanks!

Originally Posted by AliGW

No, not without VBA. Is that an option?

Hi, yes. that is an option.