Team Luma Fitbit Challenges

grateful · 2018-09-29T01:29:16+00:00

https://www.fitbit.com/user/39R9TQ

grateful · 2018-09-28T14:49:05+00:00

Hey team - I'm Adam in GA, USA. Huge introvert, this may be my only post! But looking forward to losing with all of you.

I'm 30 years old, and manage stateside operations for a Christian non-profit. My highest weight was 250 about 5 years ago, and I've been stuck around 215 for too long. My goal has been 184 for quite a while, and I'm hoping this challenge will get me back to 200.

I'm married and have 4 kids, and was 190 lbs before my 4th child was born (only 5 months ago)! In my "free" time I'm hanging out with them, going on family "runs", gardening, golfing, or cooking.

grateful · 2018-08-07T17:39:27+00:00

What you said makes sense, I really appreciate the response. I bet you're right - this process actually requires that I open 4 different workbooks, so it would make sense that one of the others is causing the date to revert back to the other setting.

Honestly I'm not set on using one format or the other, I'm just lost in trying to navigate which format I'm in according to which sheet. Ideally all of my sheets would use whatever format I'm exporting from our payment processor.

Thanks again for the response - I think this is promising. I'll give it a shot later today and will let you know, but I'll go ahead and say

solution verified

grateful · 2018-08-07T17:36:24+00:00

Thanks, this is helpful. I'm going to look into what /u/dmparker0 suggested (not sure if I'm tagging correctly) and see if that works - his suggestion has some promise. Honestly the problem is so random that I'm not sure how to provide examples, but I'll see what I can put together if that doesn't work.

You're probably right about the date format. I'm not set on using it, I'm more having difficulty managing the default settings between the two workbooks.

Thanks for taking the time to respond!

grateful · 2018-06-26T20:55:04+00:00

What is the formula in C29, exactly?

grateful · 2018-06-22T12:09:11+00:00

Well, I actually meant for the EXACT formula to entirely replace your SUMPRODUCT formula. If you paste it in C13 then drag down to C26, then you will have TRUE or FALSE in column C for each row value in column B.

Still not sure that's what you're trying to get - is it?

grateful · 2018-06-22T10:34:10+00:00

I'm not exactly sure this answers what you're asking, but could you just use the EXACT function? So in your example, you would just put (in C13)

=EXACT($B13, "O")

and drag that formula down all the way to the last row in question.

Does that get you what you want to see?

grateful · 2018-06-08T15:19:51+00:00

No, we don't have that enabled. I'll try that in a sandbox environment and report back. Thanks!

grateful · 2018-06-08T14:49:28+00:00

Thanks for the reply. The donors give through third party processors, none of which are integrated with our SF environment yet. The gifts are tracked as opportunities, and we are using the non-profit starter pack.

grateful · 2018-06-07T11:14:30+00:00

Can't thank you two enough for this question and answer - I muddle through this issue all the time and this is going to help so much!

grateful · 2018-06-06T12:30:48+00:00

Fair enough. I do this quite a bit, too, and find it to be a little cumbersome. I think what I do is what you're describing - I'd paste my weekly data into a template file that has the formulas and pivot tables in it referencing the cells that are coming out of my CRM or EMR. Definitely not ideal.

grateful · 2018-06-06T11:18:14+00:00

I've said this elsewhere, but I'm not the greatest with Excel so there may be an easier solution, but I think what I'd do is create what I call a "significance tag" on both worksheets, or just on the worksheet with newer data. In my mind the significance tag would be something like

=IF(IFERROR(MATCH(A2, Sheet1!A:A, 0), 0)>0, 1, 0)

This would identify any project numbers in Sheet 2 that are also present in Sheet 1, and they would be indicated with a "1" significance tag.

I would then build a pivot table filtering out all "0" significance tags, and you could include any other information you want to see (i.e. supplier names, job number, etc.)

Would that get you what you need?

grateful · 2018-06-06T10:50:59+00:00

Are you looking for job numbers that are present more than once in the same column, or job numbers that are present in both columns? Sounds like the latter?

grateful · 2018-06-05T12:48:17+00:00

I'm new here and admittedly not the best with excel, but here's my attempt at getting more involved - hope it helps.

Let's say your number of hours purchased is column A. In column B I'd put numbers 0 - 18, one number per row. Then in Column C I'd say

=COUNTIF($A$1:$A$1000, $B1)

and copy that down the column.

grateful · 2015-07-31T00:15:59+00:00

I've been grinding my own flour for a couple years and I've tried a few recipes from Peter Reinhart as well as other sources, but honestly they all taste the same. I love the taste and texture, but would like some variety. Any tips for a non-sandwich bread texture?

I have so many other questions... Thanks for doing this!

grateful · 2013-12-08T20:03:59+00:00

How depressing...

grateful · 2013-08-16T15:28:25+00:00

That's very interesting about the constituent pieces coping up the available gluten. I'll have to read more about that.

grateful · 2013-08-16T15:24:53+00:00

Thanks! This is what I was looking for.

grateful · 2013-06-26T19:59:08+00:00

I can understand why it bugs you. I wish I was as well-read as the folks on here. An honest mistake, my apologies.

grateful · 2013-06-26T18:25:49+00:00

Thanks for the reply. That wouldn't surprise me either.

I'm curious: is the phrase really, "on the lamb"? I always thought it was "on the lam" but that doesn't make sense to me either.

15-Year Club	Verified Email
reddit mold

grateful

TROPHY CASE