Reporting on cells without formulas

Three columns: Status (RYBG, entered by project team or PM), Task State (formula) populates depending on what is in Status and % Complete, % Complete (entered by project team or PM)

For quality control: I'd like to be able to identify if a Task State cell doesn't have a formula.

Can I set this up as a filter in a report?

Task state - does not contain - =

or is there something else?

Thanks for any help or suggestions.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!