Update Connected Board Column Based on Dropdown Column

Is there a way for us to perform the following?

We have a column named ‘Project’ because we cannot show a connected board in a form view. We want to say 'If Project Column = College, set Connected Board Column to ‘719 E College Street’. Is this possible?

Thanks,
Beth

Hi @turnkey24 - How many potential projects do you have? If you have 38 or less, you can use a status column and then automate off of that. If you need more than 38 options, you’ll need to use something like Integromat to check new form submissions and edit them based on the content of the Project Column.

Hi @PolishedGeek! I cannot seem to find an automation which populates a connected board field. Maybe I am missing something?