Need help with a simple Status Formula

MJones77

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

Ketch Pablo

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!

Ketch Pablo

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. https://help.smartsheet.com/articles/2482646-view-modify-delete-cross-sheet-references-formulas#:~:text=Edit%20the%20formula,-You%20can%20edit&text=Click%20the%20name%20of%20the,new%20sheet%20or%20cell%20range.

Vince Darrigo

Any screensnip or further detail on what you want the formula to do with/to the statuses would be great :)

MJones77

stat1.PNG

stat2.PNG

I need something that when every time someone updates the status in the tracker (stat1 image) my metric sheet (stat2 image) automatically updates.

Ketch Pablo

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!

MJones77

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

Ketch Pablo

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. https://help.smartsheet.com/articles/2482646-view-modify-delete-cross-sheet-references-formulas#:~:text=Edit%20the%20formula,-You%20can%20edit&text=Click%20the%20name%20of%20the,new%20sheet%20or%20cell%20range.

MJones77

Thank You so much, Ketch!

Your patience and knowledge are much appreciated!

Matt