How to select column name when typing a formula?
TomW
✭✭
I often use formulas like COUNTIF, SUMIFS etc. where I want to select an entire column as a range, e.g. =COUNTIF([Date of Issuance]:[Date of Issuance], [Date of Issuance]@row)
If I was doing this in excel, I would type "=COUNTIF(" and then click on the column heading to populate the range part of the formula. This doesnt work in smartsheet.
Is there an efficient way to do this in smartsheet or do I have to type out the column header each time?
Tags:
Answers
-
I select 2 rows of the column then just remove the row numbers from the formula
-
Thanks. That's what I've been doing, I was just hoping there might have been a quicker way that I'd overlooked.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!