Referencing column in another sheet from row 2 only
I am trying to set up a formula that counts the number of cells containing information in the first column on another sheet. I just don't want it to count the text that is in row 1 (ie I just want it to count from row 2 onwards as I am constantly adding data to column). I don't want the formula to even reference row 1 as it creates a "hover" box that hides other data when viewing the referenced sheet on a display screen.
I have tried just selecting the cells in the column that I want but as data is added to sheet or shifted to other sheets, it is constantly reducing the range that has been selected for the formula requiring constant updating of the formula range.
Comments
-
Hi Kat,
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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.
-
Hi Kat - try this formula =COUNT({Column1}) - 1
You know you don't want ROW1 counted in the total so just deduct 1 from the total column count.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!