Cross Sheet Input Numbers
I need to imput numbers from a different sheet using
=Count for each line. If someone has a better structure idea this could be put into that would be appreciated. The issue I having to report numbers per month on the smartsheet using only cross sheet referencing.
What i have come up with so far is =Countif({C Type}, "300", {Operational Date}, "Mar 24")
The issue i have is to change that Mar 24 for each month for the numbers to be inputted. For now all numbers have been calculated manually and put in there
Answers
-
What I've seen other members do with a sheet like this is to have a Top Row locked with the value to search for. Then you can simply reference the cell in the top instead of typing in something in quotes. That way you can drag-fill the formula left and right and it will change based on what value is in that top cell.
For example:
=COUNTIFS({C Type}, "300", {Operational Date}, [Mar-24]$1)
That $1 means it locks the reference to the FIRST row of the column [Mar-24]. Does that make sense?
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!