Times Available Formula
Instead of using a doodle poll, I'm using a smart sheet form. What would be the easiest way to tally the rows and show what times each of the people have in common?
I'm thinking of a COUNT formula but I'm not quite sure how to set that up. I've attached a screenshot.
Here are the time slots for each day:
08:00 - 09:00 am
08:30 - 09:30 am
09:00 - 10:00 am
09:30 - 10:30 am
10:00 - 11:00 am
10:30 - 11:30 am
11:00 - Noon
11:30 - 12:30 pm
12:00 - 01:00 pm
12:30 - 01:00 pm
01:00 - 02:00 pm
01:30 - 02:30 pm
02:00 - 03:00 pm
02:30 - 3:30 pm
03:00 - 04:00 pm
03:30 - 04:30 pm
04:00 - 05:00 pm
Thank you!!!
Answers
-
Dear @Kris Peeters
You can create a helper column (with its name like "Common Slots Count") and insert the following function in it:
=COUNTIF([Slot time]:[Slot time], Slot time@row)
Next, right-click the helper column, and convert it to a column formula as shown below:
With the above function, the helper column (Common Slots Count) will start showing the slot times the current row has in common.
Finally, you can create a filter in the sheet that shows only those rows whose value in the helper column meets the given criteria.
Further, you can sort the helper column as Descending to show the rows with the most common slots --at the top of the sheet.
Hope this helps!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!