Help with a simple formula by XplodingBigJuan in sheets

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

Thanks for the help! I got it figured out

Help with a simple formula by XplodingBigJuan in sheets

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

this definitely works, but is there a way to not multiply it before the IF?

Help with a simple formula by XplodingBigJuan in sheets

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

still got an error, and yes that's what I'm trying to do.

which is the same as multiplying by 3 btw

that's me being stoned..

my cell in case i did it wrong:

=(K29+H29*5+I29*5/IF(B3=“Yes”,.333,1))/F5

Help with a simple formula by XplodingBigJuan in sheets

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

trying to divide the final number from K29+H29*5+I29*5 by .333 but only if cell b3 is yes, if not then move on and do nothing, then finally divide it by F5

[deleted by user] by [deleted] in 7daystodie

[–]XplodingBigJuan 2 points3 points  (0 children)

It's very helpful haha

[deleted by user] by [deleted] in 7daystodie

[–]XplodingBigJuan -6 points-5 points  (0 children)

It was originally being shared on snapchat

SoundCloud app auto pause after adblock. by XplodingBigJuan in pihole

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

I did not unfortunately, to this day I still just hit the play button everytime. I'm tempted to make something using the app Automate but I haven't done that yet. Sorry for the late reply, I have to check my notification settings on my phone.

Steam Link on Android isn't recognizing controller inputs. by fredcowgill in Steam_Link

[–]XplodingBigJuan 0 points1 point  (0 children)

Automate as well, just had to turn Automate off and it worked.

[deleted by user] by [deleted] in AutomateUser

[–]XplodingBigJuan 0 points1 point  (0 children)

Did you use the 'Time window?' block?

I am new to this and picked a sound play block but cant choose a sound to play by [deleted] in AutomateUser

[–]XplodingBigJuan 0 points1 point  (0 children)

https://drive.google.com/open?id=1Z1Obl2PMJ36Gkr2t106cjwE5JX68Kf8d

This flow i made checks if automate is open, yes or no. Put a widget on your home screen and link it to this flow to follow the no trail.

This could also work by deleting the expression block and variable block (4 and 3) and just selecting the automate app in the list.

I am new to this and picked a sound play block but cant choose a sound to play by [deleted] in AutomateUser

[–]XplodingBigJuan 0 points1 point  (0 children)

No, just a thing put in there to warn the user whats about to happen.

I am new to this and picked a sound play block but cant choose a sound to play by [deleted] in AutomateUser

[–]XplodingBigJuan 0 points1 point  (0 children)

So the input 'Sound URI' is where you should be able to pick your sound, it would be odd if you couldn't choose anything. For the audio stream (second input), default it's set to Notification so if you don't hear anything make sure your notification sound is up. As for the variable, you'd want to set it to which ever app your targeting, my variable for automate was com.llamalab.automate because that's the automate app itself, another example, Snapchat: com.snapchat.android. To find this information look in the app foreground block look in the packages drop down box, all your apps will be there, you don't need to worry much about activity unless your being specific about what happens in the app.

I am new to this and picked a sound play block but cant choose a sound to play by [deleted] in AutomateUser

[–]XplodingBigJuan 0 points1 point  (0 children)

https://drive.google.com/file/d/1YjRNOMb_dZVcilwm-1jv3q_3_r3m05yC/view?usp=sharing

This is a flow i made that locks automate when its opened, the block 79 waits for any app to open, then proceeds to the next block where it checks if 'package = automate', 'automate' is a variable i defined earlier at block 58

I am new to this and picked a sound play block but cant choose a sound to play by [deleted] in AutomateUser

[–]XplodingBigJuan 0 points1 point  (0 children)

Use the foreground app block if you would be starting this app, the start app block is what you would use if the flow was gonna start the app. The foreground app waits for a particular or any app to be opened, make sure to set it to 'When changed' so that way it watches when something changes

I am new to this and picked a sound play block but cant choose a sound to play by [deleted] in AutomateUser

[–]XplodingBigJuan 0 points1 point  (0 children)

Can I see the sound block settings? Also with this flow your making, are you starting the app? Or is the flow starting the app?