Greetings everyone
I'm stuck at Empty Expression.
Table 1 is a google sheet file. It has x columns and a primary key.
Every day to that table is added a column, the weekday with the x data
For example:
Monday (is added on Monday)
Tuesday (is added on Tuesday) and so on.
My problem is that my workflow has a formula that does calculations with all the Weekdays.
Example:
Balance = Budget - Monday - Tuesday - Wednesday - Thursday - Friday - Saturday - Sunday
But today for example, in the google sheet data I don't have the other weekdays except Monday and Tuesday, so I get the error "Unknown Variable" for Thursday.
I tried this solution:
I've inserted a Text Input and added all the weekdays.
I want to (Append maybe) these two data streams together so that I have all the weekdays there.
So if I run the calculations I have all the weekdays there.
I don't know if my way of thinking was right, because the Text Input I created has all the weekdays, and I don't know if that would cause a problem if that weekday exists in the google sheet as well. I'm guessing it would have to check if the column exists first, before appending them. Idea would be to append only the columns with the weekdays that don't exist on google sheet yet. So on Sunday it wouldn't need to append anything.
This solution didn't work, I got the error Empty Epxression
Right now that formula works only on Sunday, when all weekdays are inserted as columns.
Any idea how to achieve this?
(p.s Creating the weekdays as columns in the google sheet with empty rows is not an option).
