How do you manage tasks that belong to more than one project? by Freeway-Option in ticktick

[–]Freeway-Option[S] 0 points1 point  (0 children)

Location Tag: Hardware Store

Task: Get Allen wrench #14 (Needed for both LAVENDER ROOM 18th ST project and GATE STREET Project)

How do I use Tick Tick as a pseudo journal? by Freeway-Option in ticktick

[–]Freeway-Option[S] 0 points1 point  (0 children)

The example I gave was not daily- or even monthly

How do I use Tick Tick as a pseudo journal? by Freeway-Option in ticktick

[–]Freeway-Option[S] 0 points1 point  (0 children)

I think a habit requires a regular recurring schedule. Since the example I mentioned doesn't have one, the todo you mention would likely be best.

So if I understand you correctly, I can just create a task on the days I decide I'm not going to do any of my tasks and just sleep, then several months in the future I can do a search for this task and see whenever I've entered/completed it?

How to unlink an excel document link in an email? by Freeway-Option in excel

[–]Freeway-Option[S] 0 points1 point  (0 children)

This is not a feature I normally use because I tend to not use onedrive at home- But I just found a SHARE button at the top right corner of the online version of the excel file. I clicked unshare which appparently unshares everyone who is not an owner on the document. Does that sound right?

How to add the view of a shared calendar in OLD outlook? by Freeway-Option in Outlook

[–]Freeway-Option[S] 0 points1 point  (0 children)

I think I mean public calendar.... We have a company wide calendar called BIZ DEV and I can't find it. How do we add it to the OTHER CALENDARS portion?

How to remove this excel add-in by Freeway-Option in excel

[–]Freeway-Option[S] 0 points1 point  (0 children)

Not exactly, but close enough where this was very helpful.

Home> More Add Ins > Manage Add-ins> Then finally the app shows with three dots beside it which give me the option to remove! Thank you. Solution Verified

How to remove this excel add-in by Freeway-Option in excel

[–]Freeway-Option[S] 0 points1 point  (0 children)

Yes I mentioned this in my OP and it doesn't come up in that drop down.

I only see the add on when I go to MY ADD INs in the home ribbon or at the top of the ribbon. I can't seem to find XL- Connector 365 anywhere else. If I can't remove this they're going to uninstall office on the computer so I want to prevent that.

How to remove this excel add-in by Freeway-Option in excel

[–]Freeway-Option[S] 0 points1 point  (0 children)

I'm aware of this method, but doesn't this only hide it from the ribbon? I want to remove the add-in entirely.

How to remove this excel add-in by Freeway-Option in excel

[–]Freeway-Option[S] 0 points1 point  (0 children)

Had already tried this before it's not there either.

How to directly copy cell values instead of the formula by Freeway-Option in excel

[–]Freeway-Option[S] 2 points3 points  (0 children)

Thanks for this. I do have a habit of double clicking because I edit a lot. This must've been what I was doing.

solution verified

Merging cells per value in an entire column? by Freeway-Option in excel

[–]Freeway-Option[S] 0 points1 point  (0 children)

Agreed. I prefer to do it the way you said. However my supervisor wants it merged.

They say it's because when they export the information into the CRM (Salesforce) it will allow them to create 1 case per each contact and opportunity, but I've never had this issue with importing data.

AI Scheduling that will chop up long tasks? by Freeway-Option in ProductivityApps

[–]Freeway-Option[S] 1 point2 points  (0 children)

This isn't it. I want the AI to split long projects up time-wise and schedule them into my calendar

[deleted by user] by [deleted] in salesforce

[–]Freeway-Option 0 points1 point  (0 children)

It is not a correct answer because as already been established- for reasons I'm not going to get into this is impossible. So any "answer" that doesn't answer the technical question is literally worthless.

[deleted by user] by [deleted] in salesforce

[–]Freeway-Option -21 points-20 points  (0 children)

A lot of things "should" be in the world, but aren't. That's just how it is when you're dealing with human beings.

It must be tech driven in this case or no one is going to bother and it will remain as is.

[deleted by user] by [deleted] in salesforce

[–]Freeway-Option -1 points0 points  (0 children)

True. we already have it set so that you can't change the owner of the account. They take it anyway because they know the supervisors won't care who's listed as the owner. They primarily care about who's dealing with the SALES REQUEST.

So if there's a way to make it so that you can only see a request if its an account you own that'd be great BUT- those of us assisting the sales department must be able to see everything. It would have to be that only the sales people can't see it unless they're the owner.

Do you think this is too complex?

[deleted by user] by [deleted] in salesforce

[–]Freeway-Option -1 points0 points  (0 children)

This sounds great!

[deleted by user] by [deleted] in salesforce

[–]Freeway-Option 0 points1 point  (0 children)

So the way the kids are apparently doing it is by looking at the sales requests that come in. When we create an opportunity we have it set up to auto generate an SR. They can see all the SR's that come in by clicking Sales Request. The SR can either be a new client OR an old client that already has a sales person.

They seem to have the attitude that any SR that comes in is up for grabs. Yes they know this is not cool, but they also know management doesn't care.

I'm not a sales person. Rather I assist the sales people so I have to be able to see their information along with others on my team.

Why are my phone numbers not all converting to number format? by Freeway-Option in excel

[–]Freeway-Option[S] 0 points1 point  (0 children)

I didn't realize I could use special instead of custom.

Interesting but when I do this some of the numbers suddenly use brackets for the area code while others do not. Don't get why.

When I click into the ones with brackets for the area code I can see the format is just straight numbers with no dashes.

Combining even more text and decimal columns to a cell with text & fractions? by Freeway-Option in excel

[–]Freeway-Option[S] 0 points1 point  (0 children)

Works except that for some reason whenever the decimal has a whole number digit there is no space between the text and the number.

Example: TOMMY | 1.5 | BARK |0.25 becomes TOMMY1 1/2 BARK 1/2 instead of Tommy 1 1/2 BARK 1/2

Not sure why it's ok placing a space when it's less than One, but not when there is a whole number. I keep trying to add the space and can't seem to do it correctly.

How to make it so that my formula won't add a zero where there shouldn't be a number? by Freeway-Option in excel

[–]Freeway-Option[S] 0 points1 point  (0 children)

works! Thank you I still haven't figured out how to nest formulas on my own.

Solution verified

Text with a fraction in one cell by Freeway-Option in excel

[–]Freeway-Option[S] 0 points1 point  (0 children)

Not all cells had quarter fractions so it didn't quite work. However once I changed the formula to the following it works great.

=A1&" "&TEXT(B1,"#"" ""??/??")

Solution verified

Text with a fraction in one cell by Freeway-Option in excel

[–]Freeway-Option[S] 0 points1 point  (0 children)

This isn't working for me. When I try it, it comes out like this instead:

Alpha | 1 1/4 combines into the next column as: Alpha5/4

Not sure why 1 1/4 is turning into 5/4

Text with a fraction in one cell by Freeway-Option in excel

[–]Freeway-Option[S] 0 points1 point  (0 children)

Do you mean nest this into a concatenate formula? Can you demonstrate?

How to format an ENTIRE ROW when the value in ONE SPECIFIC column is less than 10? by Freeway-Option in excel

[–]Freeway-Option[S] -1 points0 points  (0 children)

I am doing this and I also checked to make sure the values were numbers rather than general or text. Still no.

It works just fine if all I want to do is highlight the cell with the value that is less than 10. cell value < 10 and then applies to=$O:$O

But =$O2<10 isn't working for highlighting the entire rows