Hello! I have a table like:
|Donald||Name1||$150||Sun, Mon, Tue|
|Joe||Name2||$130||Sun, Mon, Tue|
|Alex||Name1||$130||Sun, Mon, Tue, Wed, Thu|
|Cookie||Name1||$130||Sun, Mon, Tue, Wed, Thu|
|Alicia||Name2||$130||Mon, Tue, Wed, Thu, Fri|
|Doris||Name1||$130||Wed, Thu, Fri|
Now in Excel I can easily do this in a separate table worksheet:
Thus, I can do math based upon value. I want to be able to draw from my schedule column (Sun, Mon, Tue, Wed, Thu, Fri) and get the amount of labor (predefined amount of $#, consistent among everyone so it doesn’t need to be different per line) for I can print out the total it’d cost me on each day of the week, and a grandsum of the weekly total for each project, depending upon what’s in the project field.
I am not sure how to do this, as AirTable doesn’t make calling from other sheets/table easy like Excel does.