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
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 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!