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 information? 👀 | 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
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!