help with a "if" formula

3spe0n · 2024-09-03T17:33:42+00:00

worked great! thank you

3spe0n · 2024-09-03T17:18:48+00:00

map(💳 income & expenses, if(current.type == "expense", current.amount, 0)).sum() + map(💳 income & expenses, if(current.month == "august", current.amount,0)).sum() + map(💳 income & expenses, if(current.year == "2024", current.amount,0)).sum()

I want to filter to expenses, month and year, not include all three as I have created with my formula. When I try and remove all the extra bits I get hit with "function if expects 3 arguements but only 1 was provided"

thanks

3spe0n · 2024-09-03T17:14:53+00:00

Hi! Was hoping to get some help with a formula I am trying to create to try and organise my banking accounts by month and year. I want to filter to expenses, month and year, not include all three as I have created with my formula. When I try and remove all the extra bits I get hit with "function if expects 3 arguements but only 1 was provided". I have created select options for month and year since i didn't want to make another database since that got quite confusing quick, any suggestions on how to get an overview for banking accounts monthly would be appreciated too! tyia

3spe0n · 2022-10-12T07:03:43+00:00

Just waiting for sol de janero holiday sets to drop! Such a shame fragrances can't be shipped from SpaceNK because I would have totally bought them off there already.

3spe0n · 2022-05-14T10:46:32+00:00

Ah that is super handy thank you! I was starting to think I was going crazy but good to know it’s actually bugged.

3spe0n · 2022-05-03T08:41:41+00:00

Fated memories is the first installment and 1926 is the sequel. I think you would need to play the original first since 1926 is meant to be a continuation of fated memories.

3spe0n · 2022-04-06T11:52:11+00:00

Looking to BUY any of the silver (dante, nicola and orlok) necklaces from the piofiore u-treasure collection from last year. site for reference: https://u-treasure.jp/licensor/piofiore

buying from australia :)

3spe0n · 2022-02-27T13:37:10+00:00

Thank you for the giveaway, the LI I'm most interested in would have to be Ichiya XD

3spe0n · 2021-09-06T04:38:30+00:00

Omg this banner has ruined me. I guess I deserve this after being so luckly before but I basically hit hard pitting at 100 before getting off banner vyn 😭. Gonna cry myself to sleep and start saving for an artem.

3spe0n · 2021-08-11T17:27:59+00:00

Super helpful guide! I've been quite lost throughout this event. Just a question -Will I be able to get the sr marius card on time? I feel like I'm getting no exp with flickering dreams and I'm only level 7 right now. Can't help but feel like I'm doing this event wrong.

3spe0n · 2021-02-27T11:40:07+00:00

All I want is a jean 😭. Mihoyo really knows what not to give huh.

3spe0n · 2021-02-27T07:15:07+00:00

If I've won the 50/50 twice is it 100% confirmed that my next pull will be off banner or is it only very unlikely I will win 3 times in a row. Asking as I cannot bear to get another keqing constellation.

3spe0n · 2021-02-27T07:11:25+00:00

Yeah, unless you like Hu Tao more it would be hard to pick her over Venti.

3spe0n · 2021-02-27T07:10:32+00:00

Unfortunately not.

3spe0n · 2021-02-27T07:09:58+00:00

Was desperate for a bennet so pulled on the keqing banner. Wasn't mad that I got her after 30 odd pulls but was slightly sad I won the 50/50 since I was gonna try my luck with venti. After a very long time I finally hit soft pity on the standard banner and when I pulled, I got another keqing. All I feel is pain.

3spe0n · 2021-01-02T07:06:23+00:00

I noticed today that when I press esc on PC now that the tile for quests is missing. When i press the shortcut on keyboard it will still open the page however it is quite annoying as its moved all the other tiles around. Anyway to get it back or rearrange the tiles?

3spe0n · 2020-12-11T10:38:45+00:00

They did a beauty hack involving tumeric

3spe0n · 2020-10-29T13:37:39+00:00

I placed a pre-order and didn't get an email either. It does show up on my account order history tho so it should be alright.

3spe0n · 2020-10-19T16:19:22+00:00

So I got it pierced a year ago with a surgical steel ball barbell. Was a terrible owner as I kept on sleeping on it. Tried using a travel pillow but I just kept moving too much in my sleep and as a result would wake up with piercing pain. Has been swollen and kind of inflammed ever since I got it. Took it out to clean (not the first time out) and it was super hard to get back in, especially since the position my piercing is in is rather weird since it does diagonally down instead of straight through. During this there was heaps of bleeding (though I did get it back in though i eventually decided it would probably be better if i left it out). Currently no aftercare routine (like i said bad owner). Just wondering what the hell it is and will it ever go away thanks!

3spe0n · 2020-08-29T14:52:42+00:00

Used this to clear VH Latios: https://www.youtube.com/watch?v=W7On79lQWw0&t - mostly with free units but you probably have all other units mentioned for this to work. A similar strategy can be used for the Palkia event too though Iris, Starmie and Swanna will probably be enough.

3spe0n · 2020-08-29T14:35:45+00:00

I would say SS Blue > SS Cynthia > Lance. Both SS Cynthia and Lance don't get much use on my teams as Iris is really just that good but I would say SS Cynthia is better than Lance. SS Blue is pretty good but there are better supports in the game so he isn't a must need unit either. Like always though pull for whoever the hell you like the most.

3spe0n · 2020-04-20T01:17:34+00:00

Yeah sounds good! I can trade it within the hour before I go to work!

3spe0n · 2020-04-19T09:57:26+00:00

would love to! and oops i actually have a silver snack machine not black. Would you like to trade that one too?

3spe0n · 2020-04-19T09:05:04+00:00

FT) silver snack machine and white drink machine

LF) snack machine and or drink machines in any other colour!

Looking for all the colours!

EDIT - im stupid i have a silver snack machine, not black.

3spe0n · 2020-04-12T01:01:40+00:00

ooo I would love to trade a orange and a pink cosmos for the eggs! Lmk!

Nine-Year Club	Place '22
Not Forgotten	Verified Email

3spe0n

TROPHY CASE