How to count crosses and starts
Hello,
I have a production chart where with times of 6am,9am,2pm,5pm,9pm,2am,4am. At any given time, under those boxes at any given time we can have a box labeled Start or Cross. I have created another sheet to track starts and crosses but how do I get it to automatically pull from my chart to the tracker? To clarify, if I had 4 starts for the day, and 7 crosses, how do I get that to translate to my tracker under starts and crosses each day of the week?
Best Answer
-
In your Tracker Sheet use a COUNTIF formula and the range component is referenced from your other sheet.
When you start typing your formula... =COUNTIF( select the 'Reference another sheet' link to reference your Chamber Status sheet, and then select the columns 6am - 4am as your reference.
Should look something like =COUNTIF({Chamber Status}, "Start") to count Starts, or =COUNTIF({Chamber Status}, "Cross") to count Crosses.
Looks like your tracker has a spot for each day of the week, and I'm unsure how you are doing that in your Chamber Sheet, but you will need different data for each day.
Answers
-
In your Tracker Sheet use a COUNTIF formula and the range component is referenced from your other sheet.
When you start typing your formula... =COUNTIF( select the 'Reference another sheet' link to reference your Chamber Status sheet, and then select the columns 6am - 4am as your reference.
Should look something like =COUNTIF({Chamber Status}, "Start") to count Starts, or =COUNTIF({Chamber Status}, "Cross") to count Crosses.
Looks like your tracker has a spot for each day of the week, and I'm unsure how you are doing that in your Chamber Sheet, but you will need different data for each day.
-
Brett Smith! thanks so much! it helped!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives