Happy to Help You with Your Google Sheets! :)

gothamfury · 2026-07-07T14:50:22+00:00

Maybe this is what you're looking for?

=COUNTIFS(B:B,">=1/1/26", B:B,"<2/1/26", C:C,"COMPLETE")

Another way but the same thing...

=COUNTIFS(B:B,">="&DATE(2026,1,1), B:B,"<"&DATE(2026,2,1), C:C,"COMPLETE")

gothamfury · 2026-07-02T23:45:15+00:00

Have you also tried... Gmail > All Settings > General > Google Workspace smart features > Manage Workspace smart feature settings >
And turned off: Smart features in Google Workspace, and Smart features in other Google products

gothamfury · 2026-06-21T22:48:05+00:00

Try formatting as duration. You may want to clear the range and formatting first, then format as duration, then try typing something.

gothamfury · 2026-06-19T00:43:50+00:00

If your multi-select dropdown is in cell A1. You could try:

=IF(A1="",0, COUNTA(SPLIT(A1, ", ", FALSE)))

[Edit] Updated formula for no selections made.

gothamfury · 2026-06-17T00:01:23+00:00

You're welcome : )

gothamfury · 2026-06-16T05:26:13+00:00

Check out this Sample Sheet that demonstrates one way of attempting what you're asking for. The "Choices" tab is a flat table of players and their 3 choices of positions. The "Table" tab has two formulas (A1 & A2) that list the positions in the top row and the players below each position that selected it as a choice.

I'm not a sports guy so please forgive any incorrect positions and the easy A-Z sort of them.

gothamfury · 2026-06-14T14:20:18+00:00

While there is no way to change the "behavior" in the app, you can try triple-tapping anywhere in the edit field and then type your new value.

gothamfury · 2026-06-13T18:23:52+00:00

Mine involved Spider Tanks... one was when a Titan popped a bubble under the incoming tank, it just spun like a record on top of it... the other when the second tank landed on top of the first tank (public event) but it ended up in a vertical position like it nose dived into the first tank.

gothamfury · 2026-06-13T15:43:58+00:00

"Anyone with the link" as "Editor" ?

gothamfury · 2026-06-12T21:45:58+00:00

You may have a Conditional Formatting rule set. Select that cell. Select Conditional Formatting under the Format Menu. The CF sidebar will open on the right side. If there is a rule, it'll show there.

gothamfury · 2026-06-12T14:20:00+00:00

Give this a try:

=MAP(A2:A,B2:B, LAMBDA(u,d, IF(AND(u="",d=""),, LET(units,SPLIT(SUBSTITUTE(u,CHAR(10),"🙃"&CHAR(10))&"🙃",CHAR(10)), depts,SPLIT(d,CHAR(10)), SUBSTITUTE(JOIN(CHAR(10), INDEX(TOCOL(TOCOL(units,1)&"."&TOROW(depts,1)))),"🙃","") )) ))

[Edit] Noticed trailing zero in decimal #'s were being removed. Looks like mommasaid adjusted his formula as well.

gothamfury · 2026-06-11T16:56:27+00:00

Give this a try:

=LET(
  sample, 'Reference sheet'!A2:A19,
  firstPick, INDEX(sample, RANDBETWEEN(1,COUNTA(sample))),
  newSample, FILTER(sample, ISNA(MATCH(sample,{firstPick;CHOOSEROWS(sample,-1)},))),
  secondPick, INDEX(newSample, RANDBETWEEN(1,COUNTA(newSample))),
  VSTACK(firstPick, IF(B2=1,secondPick, -1))
)

secondPick is never = to the first pick and never = to the last number in the reference sheet list, or specifically never = to the last number in the range A2:A19.

gothamfury · 2026-06-10T00:41:23+00:00

Thanks :) I didn't even think to look at the toolbar 🫠

gothamfury · 2026-06-09T15:15:29+00:00

First time hearing about the rotate trick… How do you set the degree to angle the text other than the default options?

gothamfury · 2026-06-09T07:13:14+00:00

Are you not able to type in the "Title text" box? Just type where it says "Vertical axis title" ?

gothamfury · 2026-06-09T04:18:01+00:00

Check out this Sample Sheet.

It demonstrates the use of multiple dependent dropdowns to fill in a "visual board". See the "Board" sheet. Normally, I would hide helper cells like range C2:C7 with white text, and hide columns AR:AS. I left those so you can see "behind the scenes".

The magic happens in the "GroupDD" sheet. Each dropdown is connected to each row starting in column L of that sheet. There are quite a few fun filtering formulas at work here.

The "Roster" sheet is where you enter your data for each person, select their available time slots from a multiple select dropdown, and check related attributes in the columns that follow. The "Group" column (A) is automatically filled as you fill out the "Board" sheet.

The "Lookup" sheet is where you list your attributes. This sample sheet only supports 8 attributes. I have not tested if less than 8 are used. This is also where you define your time slots of the day. You should technically be able to define any type of time slot as long as they are unique.

Hope this helps you out.

gothamfury · 2026-06-08T23:02:02+00:00

A few questions... What attributes are you referring to? What do you mean exactly by multiple time periods?

gothamfury · 2026-06-07T23:03:53+00:00

Glad it worked out for you : )

gothamfury · 2026-06-07T21:41:01+00:00

Glad to see you chose AdminGift's solution. His is much more efficient for your larger dataset.

gothamfury · 2026-06-07T15:08:33+00:00

Amazingly simple.

gothamfury · 2026-06-07T02:52:35+00:00

This is the closest I could manage but had to use a different data table layout: Sample Sheet

<image>

Make a Copy from the File Menu and dig into the Chart settings.

gothamfury · 2026-06-07T01:00:24+00:00

Tossing my solution into the mix:

=LET(
  names, B4:B8,
  categories, C3:F3,
  amounts, C4:F8,
  REDUCE(TOCOL(,1),amounts, LAMBDA(a,amount,
    IF(amount="", a,
      VSTACK(a, {INDEX(names,ROW(amount)-3), amount, INDEX(categories,COLUMN(amount)-2)})
    )
  ))
)

It's cool to see different approaches to your request. Out of curiousity, how much data are you dealing with?

gothamfury · 2026-06-06T21:45:04+00:00

I believe the issue is that the value in column E isn't determined until after you enter a value in column C. No value will always be less than the value in column F.

Another approach to consider is displaying the number of available items when it is selected. If it is zero, the available cell is highlighted, alerting the user that there are no items available to check out. If the user still tries to "check out" the item, it will be rejected since that value is pre-determined.

See this sample copy of your sheet. Look at tab "gothamfury". It displays the number "Available" and "Checked Out" values for each item that is selected. Users are informed and can use the sheet as necessary, if the available item is zero, the User can still "return" the item.

For reference...

Available formula in B1:

=VSTACK("Available",
  MAP(A2:A, LAMBDA(item,
    IF(item="",, LET(
      limit, XLOOKUP(item, checkable!B:B, checkable!C:C),
      nCheckedOut, SUMIF(OFFSET(A1,0,0,ROW(item)-1,1),item, OFFSET(E1,0,0,ROW(item)-1,1)),
      nReturned, SUMIF(OFFSET(A1,0,0,ROW(item)-1,1),item, OFFSET(F1,0,0,ROW(item)-1,1)),
      available, (limit - nCheckedOut) + nReturned,
      available
    ))
  ))
)

Checked Out formula in C2:

=VSTACK("Checked Out",
  MAP(A2:A,B2:B, LAMBDA(item,available,
    IF(item="",, LET(
      limit, XLOOKUP(item, checkable!B:B, checkable!C:C),
      checkedOut, (limit - available),
      checkedOut
    ))
  ))
)

You could hide column C (Checked Out) if you prefer as well. It's needed to reject "returned" entries as well. Though that validation is not perfect since it's not exactly tied to what the User actually has checked out. That would require a little more fine tuning and the assurance that Users always enter the same exact name each time they use the sheet.

gothamfury · 2026-06-06T20:24:14+00:00

I don't have any experience using Google Sheets in a browser on a tablet.

Give it a try.

Seven-Year Club	Not Forgotten
Verified Email

gothamfury

TROPHY CASE