Auto Fillout Data

[strisnojoyo]

Hi,

I want to be able to auto fillout the data, but I am not sure what formula to use. Please see the table below, so if someone clicked on the email column on the right, I want the Appsheet, to auto fill out that the Team is going to be Team 1 for example.

[Steve]

help.appsheet.com

App Formulas and Initial Values

How you can set app formulas and initial values to dynamically assign values.