Hello Everyone! I’m new to AppSheet and this is my first post.
I have a TAX column to calculate and add sales tax to the total. I live in a state that does not use sales tax but I would be regularly be working in a state that does have sales tax. I am trying to learn how to use the expressions to do something like this pseudo code:
If [ADDRESS] contains “WA”, calculate [TOTAL MATERIALS] + [TOTAL LABOR] + [TAX] = [TOTAL], otherwise calculate [TOTAL MATERIALS] + [TOTAL LABOR] = [TOTAL]
I know the syntax above is incorrect, I just wanted to made it readable. Does anyone have a suggestion of how the expression should actually look to work?
Thank you in advance!