Reference Number of Contacts In Cell
Greetings
Is there a way to reference the number of contacts in a given cell within a formula?
For instance, I have a column titled "hours per person", and a column which is a contact list where I enter contacts. I would like to construct a formula for the "total hours worked" which would be the hours per person multiplied by the number of contacts.
Thanks
Best Answer

=COUNTM([Contact Column]@row)
Answers

=COUNTM([Contact Column]@row)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.9K Get Help
 65 Global Discussions
 71 Industry Talk
 385 Announcements
 3.6K Ideas & Feature Requests
 56 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 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!