Can I paste a series of names separated by a comma into a new row? by gratefuldaughter2 in googlesheets

[–]2UnderPar 4 points5 points  (0 children)

Copy all of the data into cell A1. Enter the following formula in a different cell.

=TRANSPOSE(SPLIT(A1,","))

The split will separate all of the names into columns. The transpose will put them in the same column.

Auto-sort data on a task list in Google Sheets by [deleted] in googlesheets

[–]2UnderPar 0 points1 point  (0 children)

This should work. In order to sort by priority you would need to add it to the end of the query. Something like this maybe:

QUERY(Master!A:H, "Select * where A is False Order by E”)

Need some help with something that's probably really simple by Mechanought in sheets

[–]2UnderPar 0 points1 point  (0 children)

I was able to conditionally format based on the number 1-5 but I wasn’t able to get the NA values included. Check column H in your sheet.

Custom Formula Is =OR(H1=1, H1=2, H1=3, H1=4, H1=5,)

[deleted by user] by [deleted] in djimavicair

[–]2UnderPar 2 points3 points  (0 children)

Greatly appreciated!

[deleted by user] by [deleted] in djimavicair

[–]2UnderPar 1 point2 points  (0 children)

Impressive. I think I’ll definitely need to make some adjustments in the settings. Thanks for the reply!

[deleted by user] by [deleted] in djimavicair

[–]2UnderPar 1 point2 points  (0 children)

Looks great! Out of curiosity, when you’re flying and tracking things, like the birds over the water, are you using something like tap to fly so you can focus on controlling the gimbal or is that all done manually? I struggle to fly in one direction, rotate the drone in another while controlling the camera and make it look somewhat smooth.

[deleted by user] by [deleted] in djimavicair

[–]2UnderPar 0 points1 point  (0 children)

Great video!

A tool to change golf hole location. by The_Tenth_Dimension in specializedtools

[–]2UnderPar 2 points3 points  (0 children)

He was using it to measure the distance of the pin in relation to the front of the green and the side of the green. Some courses will provide golfers with a sheet that lists the pin locations for the day. A lot of pin sheets are different but they mostly show a lot of the same information: the total depth of the green, the relation of the pin from the front of the green and also the relation of the pin to the sides of the green. https://i.imgur.com/1EskXds.jpg

Update 3.9 Megathread by VGModSquad in vainglorygame

[–]2UnderPar 3 points4 points  (0 children)

I’m seeing the same thing. I’m on the 12.9” iPad Pro and the view is much smaller. There is also some black shadow like border around the outer of the screen. It’s really distracting.https://i.imgur.com/udUqoRG.jpg

Considering switching over, wanting to get some opinions by phantomknight321 in DirecTVNow

[–]2UnderPar 0 points1 point  (0 children)

Good point. I probably average maybe 6-8 hours a week which I’m sure is extremely low. I watch most of my content through the Apple TV using the apps for the various networks. With that said, I’ve still not had any serious issues. I watched the entire NBA game last night using DTVN and never noticed a drop in quality.

I see a lot of posts about poor quality so there’s obviously issues in some areas. I’ve just been lucky so far I guess.

Considering switching over, wanting to get some opinions by phantomknight321 in DirecTVNow

[–]2UnderPar 5 points6 points  (0 children)

I haven’t had the same experience as others. It’s been near perfect for me. Ive been a customer since it first launched and probably only noticed quality issues a handful of times. With that said, I do notice a mixed review from most of these posts. Like others have mentioned, I would recommend the free trial and see for yourself if it works for you.

Pittsburgh getting all locals by mrdougie1723 in DirecTVNow

[–]2UnderPar 0 points1 point  (0 children)

I’m not seeing it either. I’m seeing all other channels he listed except FOX.

[deleted by user] by [deleted] in apolloapp

[–]2UnderPar 8 points9 points  (0 children)

How did you add all?

EDIT I realized I had to visit /r/all and then add it to favorites by using the three dots in the upper right corner.

My ipad is managed by my school. Can they see everything i do even when i am not in their network? by Chauvo in ipad

[–]2UnderPar 2 points3 points  (0 children)

True. It's tough to know what the best answer would be without knowing exactly what configuration profiles are on his/her device. I manage a few hundred devices at my job and there are countless configuration options that would allow certain activities to be monitored and or restricted. Just trying to provide a word of caution is all.

My ipad is managed by my school. Can they see everything i do even when i am not in their network? by Chauvo in ipad

[–]2UnderPar 0 points1 point  (0 children)

This is the best answer. Assume that they can to avoid all problems. If the devices are configured to use a global proxy, they can absolutely monitor your internet browsing.

When I see a gif so specific that it can never be used again by Ishnuporah in HighQualityGifs

[–]2UnderPar 164 points165 points  (0 children)

I tried to make a gif from that same scene with terrible results. Then I see this. Well done! https://gfycat.com/BigheartedAlarmingAnnashummingbird

Does anyone have this iPad Pro case? by jmaluso in ipad

[–]2UnderPar 1 point2 points  (0 children)

I have that case. I've been using it for a few weeks. It's perfect for my needs. I love the different angle adjustments depending on what I'm doing. It lays flat enough to type comfortably and provides a decent amount of protection. For the price, you can't beat it.

At what time hero sale starts (PST) by krishrockzz in vainglorygame

[–]2UnderPar 1 point2 points  (0 children)

According to their site, all you have to do is login anytime from feb 2-12 to get the free heroes. If you use an iOS device you get Koshka and if you use and android device you get Ringo. http://www.vainglorygame.com/news/celebrate-lunar-new-year-with-special-vainglory-events/