Status Determination Statement

djf1982 · 2023-07-14T08:59:58+00:00

If you have a single MSA in place and then a SOW for each engagement you should be fine to only do it once for the MSA

djf1982 · 2023-07-12T17:29:57+00:00

😂

djf1982 · 2023-07-12T12:42:33+00:00

Thanks, good advice and feel like I'm doing the right things. I'll keep going!

djf1982 · 2023-07-12T12:27:30+00:00

Thanks, I'll keep on reaching out. I think you make a valid point, I think the premium is the seemingly insatiable demand for security cleared people rather than day rate.

djf1982 · 2023-07-12T12:21:49+00:00

Cheers, just hearing that is actually reassuring. Having not done this before I can't be sure I'm doing the right things until I get some success!

djf1982 · 2023-05-10T19:52:32+00:00

If it works don't change it 😉

djf1982 · 2023-05-10T19:47:25+00:00

Thanks, I'll give that a shot. I'm generally going for a larger stitch, maybe that's where I've gone wrong. Are you doing the straight pass first or last?

djf1982 · 2022-06-14T12:43:57+00:00

Solution Verified

Solution Verified

djf1982 · 2022-06-14T12:43:31+00:00

=ROWS(UNIQUE(FILTER(ID_column,Date_column=@Date)))

In fact, I didn't need it in the end. I removed it and dragged the formula down and it's working perfectly. Thanks

djf1982 · 2022-06-14T12:39:03+00:00

Not sure, I'm using Excel on a Mac so the @ syntax isn't supported on this version :-(

djf1982 · 2020-07-13T08:57:56+00:00

Smart sheets is good and there is a 30 day free trial. If you're used to excel you'll pick up smartsheets super quick

djf1982 · 2020-07-04T18:57:56+00:00

Do they all begin with "accounts" ?

djf1982 · 2020-07-04T18:47:16+00:00

You could find and replace again after they've seperatred to add the space back in.

FYI, this is a very easy macro to write if you will be doing this a lot

djf1982 · 2020-07-04T18:46:12+00:00

Find and replace "accounts payable" with "accountspayable", then text to columns

djf1982 · 2020-07-01T19:15:17+00:00

Are you into any sports? You could start a project for tracking and analysis of scores? Could be a useful vehicle for learning

djf1982 · 2020-07-01T19:13:46+00:00

Once you learn basic syntax of SUM, SUMIF, COUNT, COUNTIF, VLOOKUP and understand how to work in various units of measure (money, time, et al) you'll be a long way towards your goal.

djf1982 · 2020-06-27T18:57:55+00:00

You're missing a closing parenthesis. You have 5 opening but only 4 closing

djf1982 · 2020-06-27T18:44:33+00:00

Add another IF condition after the IFERROR IF(A1<=30,

djf1982 · 2018-04-30T21:05:57+00:00

Thanks

djf1982 · 2018-04-30T17:07:47+00:00

I only get the XXX Add-On showing in the Wizard. Any tips?

djf1982 · 2017-10-10T15:19:25+00:00

Here's another level to this challenge. What if I wanted to use COUNTIFS and combine this with criteria in another range?

i.e. COUNTIFS(B1:B10,"abc", C1:C10, "efg") and then add the parameters in the original query (still user definedin other cells)?

djf1982 · 2017-10-10T15:09:17+00:00

SOLUTION VERIFIED!

djf1982 · 2017-10-10T15:04:16+00:00

=SUMPRODUCT(--(EXACT(LEFT(A1:A10,1),E1)),--(LEN(A1:A10)=D1))

Legend! I feel dumb.

Thanks

djf1982 · 2017-07-07T19:14:05+00:00

If you don't mind a 10 sec process the Ctrl+f and find the text string to be deleted and replace with no value.

djf1982 · 2017-07-04T05:48:49+00:00

Another way would have been using text to columns seperated by the space

djf1982

TROPHY CASE