Harvey Balls / Lookup or Max ?
Dear all,
I am trying to find a smart way to use formulas to make a large data table more accessible. The situation is as follows:
I have a number of companies that are represented by one line in smartsheet. This line included a unique ID as well as names, etc. For each companies I can have 1 or more lines - children - that include specific data for a task checklist.
I am looking for a way to update some fields on the unique row with max details from the children if this does make sence. I.e. Each task list has an overall status represented by an harvey ball. If the companie has currently two additional rows and one if completed and one is at 50% I would like to have the company line show the full harvey ball and a reference field should indicate if this is task list one or two.
Can that be accomplished by use of formulas? I have some 500 single unique rows I need to manage and try to keep track off.
Thanks,
Mathias
Comments
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!