Need help with a simple Status Formula
Ok I admit, I very special when it comes to formulas in either Smartsheet or excel.
I need a formula for Statuses: New, In Progress, and Complete. This information is coming from my tracker to the metric sheet to my dashboard. How do I make this happen?
Thank You in Advance
Matt
Best Answers
-
I use this quite a lot!
=COUNTIF({Status Column}, "[Status]")
Select the Status column from the sheet for Column by clicking on Edit Reference and replace [Status] with for each corresponding status.
Good luck!
-
In the metric sheet. To select the Status Column, click on Edit Reference and you'll have to find the tracker file and select the status column.
Answers
-
Any screensnip or further detail on what you want the formula to do with/to the statuses would be great :)
-
I need something that when every time someone updates the status in the tracker (stat1 image) my metric sheet (stat2 image) automatically updates.
-
I use this quite a lot!
=COUNTIF({Status Column}, "[Status]")
Select the Status column from the sheet for Column by clicking on Edit Reference and replace [Status] with for each corresponding status.
Good luck!
-
Okay, I need a little hand holding here, Where do I put the formula? In the metric sheet or the tracker. I am getting a '#Invalid Ref" message
-
In the metric sheet. To select the Status Column, click on Edit Reference and you'll have to find the tracker file and select the status column.
-
Thank You so much, Ketch!
Your patience and knowledge are much appreciated!
Matt
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!