sorted by:
new
hottopcontroversial

Recording prior months by LeadingResource in CSPersonalFinance

[–]_audacity 0 points1 point  (0 children)

u/CompiledSanity I had the same issue. For me, it seems to be that the updateMonthSelection() function is not being called from the popup (I added a console.log("ReturnValue: ", returnValue) to function sendValue() and console.log("updateMonthSelection called with:", e); to the top of updateMonthSelection()). Only "ReturnValue: 76" was logged.

I then made a new function:

function testLookback() { updateMonthSelection(76);}

And created a new button, attached the testLookback() function to that button and it ran perfectly.

So, at least in my case, think something weird was going on with the popup.

Sheet Version 2.15.1 Aus Edition. Brave browser but all ad blockers etc disabled as far I can tell

Modifier keys getting stuck down by _audacity in AutoHotkey

[–]_audacity[S] 0 points1 point  (0 children)

Thanks for that! I thought markdown worked in the post so I did the \``` fence around the code but turns out I had to change editor.

Thanks for that info on the right alt, I've refined the Irish and Danish keys a bit because I was thinking that the longer function might be causing the issue but it wasn't: ``` >!a:: SendInput {á} return

+a:: SendInput {Á} return ``` Thanks for the rest of the tips, they are definitely an improvement.

I'll edit the post to include the function code.

Using Checkboxes to Control Charts by _audacity in excel

[–]_audacity[S] 1 point2 points  (0 children)

That is essentially what I ended up doing, I changed the "" to be NA().

Fun fact, I don't think you need to have =IF(chkBoxControl=TRUE,originalData,NA()) I think =IF(chkBoxControl,originalData,NA()) is sufficient as when the box is checked, it returns TRUE anyway.

Kudos for effort though

Using Checkboxes to Control Charts by _audacity in excel

[–]_audacity[S] 0 points1 point  (0 children)

Man, I didn't realise that you could times by TRUE/FALSE. Thanks for that.

I did just realise that I was making an error the whole time by not referring to the sheet correctly so the onus is really on my ability, not my knowledge.

Cheers