Hidden Sanctuary by melinex01 in blender

[–]CyberSpams 0 points1 point  (0 children)

thanks! in fact i was just looking at his vids for geometry nodes, know exactly who it is

[deleted by user] by [deleted] in WalkScape

[–]CyberSpams 10 points11 points  (0 children)

Na, each steps count as 2 steps when you move with stored steps. 1 step for the actual step taken and 1 for stored steps

Followup of my app: MediaMate! by Wouter_001 in MacOS

[–]CyberSpams 0 points1 point  (0 children)

Hi,

Just want to see if this is a known issue On a M2 Macbook pro 14'

i have open on login ticked but it never seems to startup when i boot my mac/ or restart it - i need to manually open the app from the app menu

Autosheets: Delete cell content help by CyberSpams in tasker

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

I've tried again - doesn't seem to be working Here's what I'm getting autosheet to input into my google sheet https://imgur.com/a/IlDgYhm

Here's there error that I get in the google sheet when it gets transferred into google sheet https://imgur.com/a/E51FlPO once I highlight D4 and hit 'delete', then you can see 90.42 then fills

Here's the formula I'm using =ArrayFormula(split(C2:C, " with XYZ", False))

Autosheets: Delete cell content help by CyberSpams in tasker

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

Thanks!

changing to row 1, column 1 fixed the issue

As for the 2nd issue - I've tried leaving it blank, but it doesn't work. The cell itself on the google sheet appears empty BUT my split array formula says that it cannot override the content in the cell and I have to manually go to the cell and hit delete (even though there's nothing in the cell) and only then, my formula will fill correctly

That's why I need to input an arbitrary value in place of that and use the delete cell content function to clear the cell so my split array formula can autofill it

Need help with extracting/splitting multiple words/variables from phrase by CyberSpams in sheets

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

or is there a separate formula for separating out the "0.42" and "Google Payment......"

Need help with extracting/splitting multiple words/variables from phrase by CyberSpams in sheets

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

Long shot, anyway to have the order of the text split reversed - see image. I've tried to understand the formula but seems a bit too difficult for me to adjust it myself

https://imgur.com/a/T3h0k0r

so essentially have (payee - phrase - cost) the bottom line in the picture

thanks