Please Help me, trouble with formula which i am not sure that is gonna work but it's accepted

AppSheet AppSheet Q&A
1

Hello

Am I able to chack my formula by changing appsheet’s date? Because I tried my formula which is little bit complicated for me is accepted but i don’t even know this is gonna work at the end of the month. Or Do I have to wait till the end of month?

Formla for virtual column ( [Calculated] )

Ps: Date is virtual column and formula for this is (TODAY())|
I just want to know that: How much money I owe to whom at the end of the month. If there is other simpler ways to do this Please reply!

IFS (month([_THISROW].[Date]) = EOMONTH(TODAY(), 0), ([Salary] - (sum(Select(PrePaids[Sum],[ToWhom]= [_THISROW].[EmployeeID])))) + [Calculated])

2

If [Date] is a separate VC with the formula TODAY(), that’s kind of pointless, just use TODAY() in your expression. You would also want to remove the “[_THISROW].” if you were to keep using the [date] VC. So either:

IFS( TODAY() = EOMONTH( TODAY() ) , …

or

IFS( [Date] = EOMONTH(TODAY() ) , …

3

  1. i couldn’t fix my complicated formula which i don’t understand either, so I am changing the way of formula and that’s gonna be simplier. Can you give me the formula of this logic and i can structure it by using your way. Logic: Virtual column needs to add itself number “10” eachday without losing its previous value. and minus sum of this column [ Expenses] (which contains daily expenses). If today’s all expenses value is 5 then show me Today: 5 (bcs 10-5), Tomorrow: 15 (5+10), Aftermorrow: 25 and etc. Mine is losing its previous value and calculating the formula again. Please reply, you would solve my headache.

  2. Btw how i can add number 3 to this column (contains this formula) not to expenses column (i can add expense form another table). If i add this 3 to this formula by doing arithmetic, it will calculate this everday but i need to add this 3 for one beggining time that’s it.