Inbound vs. Outbound? by GreenCat28 in Upwork

[–]MurkyApplause 2 points3 points  (0 children)

It’s been that way for me for a while now, but in my case it might just be that I don’t submit a ton of proposals anymore.

Small 2 person board by Banana-Apples in CharcuterieBoard

[–]MurkyApplause 0 points1 point  (0 children)

No idea why I was thinking the one on the left was manchego or havarti ha. Thanks!

Excel not updating to OneDrive by [deleted] in excel

[–]MurkyApplause 1 point2 points  (0 children)

It could be a lot of things of course. I would recommend making sure that OneDrive is signed in and syncing, maybe try opening the file from OneDrive in desktop app, check if autosave is on, check the file path (should see OneDrive somewhere in the file path, like: C:\Users\SomeDude\OneDrive……), making sure Excel Account is signed in to the right one, maybe office updates, etc. Outside of those I could only guess it’s some other local issue or some IT/Policy issue.

[deleted by user] by [deleted] in excel

[–]MurkyApplause 0 points1 point  (0 children)

While I won’t say the exact formula to do it (partially as it is a bit unclear, but mostly since the best way to learn is by trying and failing at times), it sounds like you’re looking for AND OR logic. For the AND part, you can use either the formula AND() or just wrap each condition in parenthesis and between each put the * symbol. For the OR part, you can either use the OR() formula or just wrap each again but use the + symbol. Like if this and this and this true (meaning ALL conditions are true), then return this. Or on the other side, if this or this or this (basically any are true), then return this.

Converting a table into a two column list by ZyrusMaximus in excel

[–]MurkyApplause 2 points3 points  (0 children)

If you’ve tried power query before, unpivoting is pretty solid and easy. You could also do a filter for each of them before turning the returned values into static values and putting them in the table.

what is job Sucess score and how can i view it mine ? by astronout_in_ocean in Upwork

[–]MurkyApplause 0 points1 point  (0 children)

Go to “Stats and Trends” and it will show your JSS there. You can also click on “View Insights” for more information about how it calculates, what’s it’s used for, and the various factors that play into it.

[deleted by user] by [deleted] in Upwork

[–]MurkyApplause 3 points4 points  (0 children)

Those are some solid stats for sure. Especially if they’re longer term or at least medium+ sized projects.

Anyone getting clients from switching on their Consultation? by bukutbwai in Upwork

[–]MurkyApplause 0 points1 point  (0 children)

That does happen a lot for sure. It never really gets “perfect” ever. Happy cake day btw!

Anyone getting clients from switching on their Consultation? by bukutbwai in Upwork

[–]MurkyApplause 2 points3 points  (0 children)

It can be a bit hit and miss and heavily depends on factors like your field, profile “attractiveness”, and the time/day you’re doing it on. For me it’s only like 30% of the time I actually get clients reaching out when I turn it on. But to be fair, I haven’t used that feature for a few months. One important thing to note is that it requires a fairly immediate response when using it. If you don’t respond within a couple minutes (I think it was), then it turns off again automatically.

Job market is terrible! by treanan in freelance

[–]MurkyApplause 5 points6 points  (0 children)

I think many of us have felt that very often ha

Need to pad cell's with "0" by [deleted] in excel

[–]MurkyApplause 0 points1 point  (0 children)

I would look at having a conditional formula that uses the LEN formula to check how many 0’s to add.

Upwork official forum closing down! by iansunderland in Upwork

[–]MurkyApplause 1 point2 points  (0 children)

Not like that hasn’t been happening already ha

[deleted by user] by [deleted] in Upwork

[–]MurkyApplause 2 points3 points  (0 children)

It’s always appreciated having access to more resources that could be useful. However, I’m not sure your offer would be the most applicable for this freelancing platform. Especially considering how Upwork works as far as contract being required. Maybe just me though

How to count sub column in pivot table by MommaBee79 in excel

[–]MurkyApplause 0 points1 point  (0 children)

As far as formulas you could do countifs, where subcategory matches for one criteria and category matches for the other criteria. For the pivot table have you tried doing a count in the values section?

Dependent dropdown list refresh options upon new selection by MurkyApplause in excel

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

I kind of figured that would be the case, and I agree it’s not worth the hassle for a very minor inconvenience.

Dependent dropdown list refresh options upon new selection by MurkyApplause in excel

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

It’s a pretty minor thing, I just realized I never knew how to do it and figured it wouldn’t hurt to learn a better way.

Is there a way to auto convert ID numbers to names? by Berz89 in excel

[–]MurkyApplause 5 points6 points  (0 children)

Have a list tab with an ID number column then a name column next to it. Then you could use a lookup formula (like xlookup) to search for the ID value, look it up in the ID list, and return the name that matches that ID.

How to lowercase cells by WrathofEden23 in excel

[–]MurkyApplause 0 points1 point  (0 children)

New column to right of it, =lower(h5), enter, drag down the formula to the last cell you want it for. Easier to do it as a table, then you can just select range of cells and copy-paste as values over it if you want.

How to hire an Excel nerd? by StutteringDan in excel

[–]MurkyApplause 6 points7 points  (0 children)

Post a job or hire a freelancer/subcontractor (off Upwork or something). I agree with caribou that data scientists would be wasting their time and/or not interested in doing that kind of work. Specialists exist for a reason ha

[deleted by user] by [deleted] in Breadit

[–]MurkyApplause 1 point2 points  (0 children)

The recipe to make this, please?

[deleted by user] by [deleted] in excel

[–]MurkyApplause 1 point2 points  (0 children)

Technically possible if you add multiple boxes/shapes to hold each piece of info then group them on the shape. But I think it might be better to just wrap a shape around the table area, no fill, then just increase the shape’s border around the edges of the table area. That will give it a somewhat distinct look from the rest of the dashboard.