givenchyboy

u/givenchyboy


r/sheets•

In cell F16 i have $5.31. Id like the cell the change colour if it changes to $6.31 or $4.31.
If if goes up to $6.31, the formatting would reset and go based off $6.31.

I'd also need the colour to be manually reset using a button assigned to a drawing.

​

Any help would be greatly appreciated. I know this is a lot to ask.

23


r/sheets•

i have the following formula which works fine: = $N$11/100. This Gives me $1.66, which is correct.
But when i add ="Pre-cut $"&$N$11/100 it comes out looking like Pre-cut $1.66116428 ect..

How can i fix this to it simply say Pre-cut $1.66?

12

r/sheets•

I've synced/imported my 'Price Calculator' sheet to my 'Export' sheet using the following filter:

=filter('Price Calculator'!A2:F, 'Price Calculator'!A2:A>1)

I've placed this filter in A1 of the 'Export' sheet.

I'd like to exclude columns C and D from syncing with the 'Export' sheet.
If someone could help me out with this filter, I'd be forever grateful.

34



r/350z•

As mentioned, the window will not go up. If I keep the key in the ignition, the window motor will get very hot. This happened with the 2 new motors I’ve tested.

What I’ve tried:

  • window reset.
  • slamming the door while holding up on the switch.
  • Checking if the window lock was on.
  • Turing the key in the door lock to roll it up.
  • replacing the motor and regulator.

I’m at a loss of what to do. The power locks and lights work on the switches so I’m assuming the whole thing is in working order.

Also, if I plug in the motor and don’t attach it to the regulator, the square socket on the motor continuously rotates.

UPDATE: I found the cause of the issue. The problem is the small plas

13

r/montreal•

My family owned a shoe company in Montreal during the mid 1900s. I believe the building was fairly tall and had the word ' Wayland' on it. They manufactured the shoes in the building.

The building was demolished about 5-6 years ago and my family never got to see it. The address was at 359 Providence St. I can't find this street at all, which is strange. Any help would be greatly appreciated.

​

UPDATE: The business was operational in 1935. Also, the trade index has the business located at 360 Providence St instead of 359. My hope is that i can find the street on google maps, go into street view and then set the time back to when the building was still standing.

​

UP

122


r/Landlord•

I found a bachelor apartment in an old Victorian home and have been pre-approved with a viewing. It’s recently been renovated with the addition of a kitchen and closet.

I’m a photographer that needs a large space, high ceilings and natural light, which this property offers. But I already foresee an issue, that being the closet.

It’s a very small boxed closet that’s screwed to the wall and probably glued to the floor. It doesn’t touch the ceiling. Its placement in the room is most definitely going to get in the way of utilizing the space for my work. You couldn’t place it in a worse spot if you tried.

I’ve shown multiple friends and family, with no context, and every single one eventually

28

r/steel•

I run a small steel company with one employee. We simply import and export. As or right now we are using NCH software (Express invoice & Inventoria). We like the software itself but it completely lacks when it comes to the web based interface. Its not reliable whatsoever. I can't even access the web interface from home because their tutorials are completely unclear and outdated. The software itself does not cater to the steel industry at all: searching for sizes and specifications isn't implemented in a convenient way that makes is easy for steel businesses that have a very wide selection.

We are looking for an application that can at least do the following:

  • Inventory manag
33

r/smallbusiness•

I run a small steel company with one employee. We simply import and export. As or right now we are using NCH software (Express invoice & Inventoria). We like the software itself but it completely lacks when it comes to the web based interface. Its not reliable whatsoever. I can't even access the web interface from home because their tutorials are completely unclear and outdated. The software itself does not cater to the steel industry at all: searching for sizes and specifications isn't implemented in a convenient way that makes is easy for steel businesses that have a very wide selection.

​

We are looking for an application that can at least do the following:

  • Inventory
17

r/MealPrepSunday•

After hours of searching I finally found this container that measures 7 x 8.5 x 2.5" im just not sure if this is a good size for two servings. If its too small, what size would you recommend?

I'm subscribed to Chefs Plate so I don't have to worry about making too much to store.

If you have a suggestion for a different product, please keep it 100% plastic free. I've considered glass containers with bamboo lids but i'll be keeping meals i

03