How do I show data from 2 rows in the same sheet returning the same information
Example all of this information is contained in the same sheet
Role 1 - staff 1 is an Administrator
Role 2 - staff 2 is a Scheduler
I want to ensure for each role that I am counting both rows (Role 1 and Role 2)
Best Answer
-
This is for both columns.
=COUNTIF([Staff 1 - Role]:[Staff 1 - Role], "Administrator") + COUNTIF([Staff 2 - Role]:[Staff 2 - Role], "Administrator")
For the row.
=COUNTIF([Staff 1 - Role]@row, "Administrator") + COUNTIF([Staff 2 - Role]@row, "Administrator")
Did that work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
So you want a way to check if both columns show the same role for any given row?
What about making a checkbox column with the formula:
=if([Role1]@row = [Role2]@row,1,0)
-
Hi @JessMc3
I hope you're well and safe!
Not sure I follow. Can you elaborate?
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Michael Culley would this actually count the total number of schedulers in each column?
-
Are you just wanting to count how many Admins, Schedulers, etc you have total?
And you want to count both columns in that formula?
-
@Andrée Starå I have a sheet where we have 5 columns for each staff member so 10 total columns
i want to count the number of times scheduler appears in role 1 for staff and in role 2 for staff. my boss wants a total count for the role.
Occasionally the row itself might contain a scheduler and an administrator. I would like to count each of those
-
Ok.
Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Michael Culley yes. data for 2 staff members is in the same row and may contain 2 different roles. ex scheduler and office manager.
my boss wants a count of each for the sheet.
-
-
-
This is for both columns.
=COUNTIF([Staff 1 - Role]:[Staff 1 - Role], "Administrator") + COUNTIF([Staff 2 - Role]:[Staff 2 - Role], "Administrator")
For the row.
=COUNTIF([Staff 1 - Role]@row, "Administrator") + COUNTIF([Staff 2 - Role]@row, "Administrator")
Did that work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 349 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!