Creating a field formula If a user is selected a field from another table is looked up

[C-Goad]

Hello,

I am currently running into the base exceeding automation limit and am trying to come up with a way to solve for multiple automations we have created by using a formula field or look up field.

Currently, we assign users to certain tasks and we have another field that displays their phone numbers (long text field).  I am trying to set up a formula where IF a user is selected, it would then lookup/display from another table that user's phone numbers that are list on table 2.

Is this process possible with Airtable?

[Ron_Daniel · Accepted solution]

Rather than assigning using a users field, I'd set up a table of users (probably the one you've got their phone numbers in) and link it. That way, you could just have a lookup field for the phone numbers. If a user is assigned, then their phone number will show. If not, then it won't.

[C-Goad]

@Ron_Daniel Thanks so much!