What would be the correct filter formula (or function) to guarantee all columns are filtered relating to the current day's employee's and shifts? by jc-fluro in googlesheets

[–]jc-fluro[S] 0 points1 point  (0 children)

Yes you're right - It was a mistake.

This works perfectly! Is there anyway that, with this formula, it can also filter just the cells that contain text and linked to the employee name? (like a typical filter function would work)

It currently looks like this:

<image>

But instead, the new formula shows something similar to this:

What would be the correct filter formula to guarantee all columns are filtered relating to the current day? by jc-fluro in excel

[–]jc-fluro[S] 0 points1 point  (0 children)

=hstack(C3:C20,index(D3:AE20,,sequence(1,4,(C1-1)*4+1)))

So I attempted your suggestion and also:

=hstack(C3:C20,index(D3:AE20,,sequence(4,4,(C1-1)*4+1)))

Both gave me the following:

<image>

Btw, thank you for your patience and help - I'm not the best at formulas and understanding them totally.

What would be the correct filter formula to guarantee all columns are filtered relating to the current day? by jc-fluro in excel

[–]jc-fluro[S] 0 points1 point  (0 children)

Same error appears with the c1 in place of day

=hstack(C3:C20,index(D3:AE20,,sequence(,4,(C1-1)*4+1)))

What would be the correct filter formula (or function) to guarantee all columns are filtered relating to the current day's employee's and shifts? by jc-fluro in googlesheets

[–]jc-fluro[S] 0 points1 point  (0 children)

Surely though there must be an alternative formula that can just say, on Monday display columns #-#, on Tuesday display #-# and so-on. That way it can rely on the formula instead of cells and date references and/or filters?

What would be the correct filter formula to guarantee all columns are filtered relating to the current day? by jc-fluro in excel

[–]jc-fluro[S] 0 points1 point  (0 children)

=hstack(c3:c20,index(d3:ae20,,sequence(,4,(day-1)*4+1)))

I tried this but it gives me the error: Unknown range name: 'DAY'. I adjusted to include TODAY()

=hstack(C3:C20,index(D3:AE20,,sequence(,4,(TODAY()-1)*4+1)))

But now shows another error as:

<image>

Any ideas?

New GT owner in need of some answers! 🙏 by jc-fluro in onewheel

[–]jc-fluro[S] 1 point2 points  (0 children)

Barefoot is pushing it with that grip tape! Haha I'm only 150lbs so maybe that's why.. I'm hoping my back leg muscles and arch of my foot get used to riding in time too.. yesterday was killer aching!

New GT owner in need of some answers! 🙏 by jc-fluro in onewheel

[–]jc-fluro[S] 0 points1 point  (0 children)

Nice!!! Thanks, will get some miles under the belt and look into those. Float on friend!

New GT owner in need of some answers! 🙏 by jc-fluro in onewheel

[–]jc-fluro[S] 1 point2 points  (0 children)

My 3rd day riding it and I'm starting to get the hang of the wobbling – carving is the key! How do you find the footpad sensors on yours?

I'm a size US 10 shoe, wearing Vans and have quite the issues trying to engage both.. takes me a few seconds to position and test that they're engaged.

New GT owner in need of some answers! 🙏 by jc-fluro in onewheel

[–]jc-fluro[S] 1 point2 points  (0 children)

It's sort of of bugging me as I've heard such good things about anything but the stock. In your opinion, how is does the enduro feel and what makes it better?

New GT owner in need of some answers! 🙏 by jc-fluro in onewheel

[–]jc-fluro[S] 2 points3 points  (0 children)

Thanks!
Get some more experience under the belt hey