How to Modify List Option Based on Column Formula

I’m guessing this has been asked before (and is probably really simple), but I just couldn’t figure out how to word it. Essentially, I want to make an output (and eventually a filter, but that comes later) of a column based on other column data.

I made up a quick mock up here: Coda | A new doc for teams.

I want the 3rd, final column to auto-generate the “status” based on whether or not a previous column is blank. In my (personal) doc, I have numerous software licenses that are either unassigned or assigned, and I was hoping to auto-generate a column that tells me that based on whether or not I’ve given a particular software license a home.


Please check column Status 2 a sample of a working formula.


1 Like

Yes, thank you! That’s exactly what I was looking for :slight_smile:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.