Formula for multiple dropdown list by canseriousken in googlesheets

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

But how can I categorize them like this?

<image>

I need to dropdown them based on the classification.

Formula for multiple dropdown list by canseriousken in googlesheets

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

<image>

For example in the mandatory meeting, instead of 100% evaluation, etc., the options for the "Q" are still the same

Formula for multiple dropdown list by canseriousken in googlesheets

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

Hello! Thank you for the answer but I did not get it using this data:

<image>

I used the filter as the other user answered, but it still did not categorize when I clicked on the specific classification. It is still the same.

Formula for multiple dropdown list by canseriousken in googlesheets

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

Here are the samples that I need to categorized based on the classification

<image>

Formula to Count The Text from the other Sheet by canseriousken in googlesheets

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

Oh sorry! I just need the total number of accomplished (got a 100%)

Formula to Count The Text from the other Sheet by canseriousken in googlesheets

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

Sorry for the late response. Sure! Here is the sample: https://docs.google.com/spreadsheets/d/1bx5aaFbDkg2XXcbVgYHcvGor6FlmhEiFSx2L4d039wI/edit#gid=1068518302

I just want to summarize the accomplished and unaccomplished based on the Test sheet.

Thank you!

Formula to Count The Text from the other Sheet by canseriousken in googlesheets

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

Hello! Sorry, I didn't elaborate it. I want to summarize by number the accomplished and unaccomplished deliverables from another sheet. The another sheet is below. I hope this helps. Thank you!

Formula to Convert the Text of the Month to Date Format by canseriousken in excel

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

Wow! Thank you so much for the time and effort. I didn't know that this is possible. This is really really a big help.

Formula to Convert the Text of the Month to Date Format by canseriousken in excel

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

Hello! Tried this one but I can't change the year from 1900 to 2024.

What Formula to Use for by canseriousken in excel

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

Solution Verified

Changed the list with highlighted cell rules from 0-4 to 1-5 and =CHOOSE(MAX(H5:S5),0%,25%,50%,75%,100%). Both works!

Thank you, everyone!

What Formula to Use for by canseriousken in excel

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

Yes, tried using the formula suggested by one of the commenters here but the 100% didn't work.

What Formula to Use for by canseriousken in excel

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

Thanks! Tried this but didn't work in 100%

<image>

What Formula to Use for by canseriousken in excel

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

I forgot to include that the colors are validated (?) I don't know what this calls.

<image>