How to calculate a completed task
I'm attempting for calculate if a observation was completed on a person, and mark them complete in the Q1 column of my driver list sheet. I have another sheet with the name Q1 SLC that has a column "Employee observed" that I want to match with the name in sheet "Driver List", column Driver Name. In the Q1 column I want to say complete.
Answers
-
I figured it out.
=IF(COUNTIF({Q1 SLC Range 1}, [Driver Name]@row) > 0, "Complete", "Incomplete")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.2K Get Help
- 451 Global Discussions
- 155 Industry Talk
- 505 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 514 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 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!
