I have this table of products:
I have the Project Address populated in a select list using this formula so that the only options in the select list are addresses associated with that client:
Default value is set to use the first, and usually only option using this formula:
From this table of projects:
I’m trying to pull in the sales tax % from the Project Locations table based on which address is selected, but every formula I try either lists all of the percentages or none of them.