Hi! We’re trying to figure out what formula is to be set in place for this scenario:

We have three forms, all connected to autopopulate on Airtable.

Column A = Form A

Column B = Form B

Column C = Form C

Basically, what we have a column with the formula that determines what form a client has filled out based on what Column has been autopopulated - let’s call it Column X.

What we want to happen is = if Column A has been populated, Column X says “Form A”; if Column B is populated, Column X says “Form B” and so on.

Only one column will be populated at a time per row (ex. Row 1 Column A populated, Row 2 Column B etc), so I hope that makes the formula creation easier.

Thank you in advance!