Dropdown list but add logic

KimTDSYN ✭✭✭
edited 06/19/24 in Smartsheet Basics

I have a column that is dropdown list. I want to add logic to prefill some of the cells based on a value in another column (via a formula) while leaving the rest of the cells unaffected so they can be manually changed.

For example, my dropdown is "approved" and "denied". I want to auto fill some of the cells to "N/A" so they are not actioned.

Can this be done? I can do this via conditional formatting but that just allows for formatting, not data.