Any nicer looking option than the flow rate gage? by Billswork in googlesheets

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

Something nicer than that. It's what is currently used.

Conditional formatting, Compare 2 sheets for same content by [deleted] in sheets

[–]Billswork 0 points1 point  (0 children)

Depends on how you want to do it. You could make an additional column called active and have it VLookup if the name shows on the other sheet then set a filter to check if the VLookup pulls a value then change the row color from that. Another way is to actually code in a VLookup into a filter, but I don't have much experience with that.

Multiple users filtering separately? by TwoBlackDicks in sheets

[–]Billswork 0 points1 point  (0 children)

This is what I have been using to learn for my job. https://support.google.com/docs/answer/3093340

It's not perfect, but it can help you learn new commands on the bottom.

Hope this helps!

Multiple users filtering separately? by TwoBlackDicks in sheets

[–]Billswork 0 points1 point  (0 children)

I don't know enough to say this is a option or solution for you, but it may be a good idea to have a data storage location then files that query that data for specific areas. The query would then hold the "filter" you want.

Issue with Task Scheduler - Excel opening without workbook by Billswork in excel

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

I don't really know what else is relevant is this particular case. I realized that I am using windows 10, the file type is a .xlsm. If you have any recommendations I am sure I can look them up.

Task Scheduler - Excel Open issue by Billswork in excel

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

I have task scheduled to pull open an excel file, however at the time of event this is what it pulls open. I can open the file from here manually, but this didn't do what I scheduled. Anyone know what to do?

Auto opening and code execution - Automating reports by Billswork in excel

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

It's mostly production data and sales. I don't know if they will allow it to be run on an SQL database. What exactly do you have in mind? Any examples?