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.
Thanks
Answers

Still not sure if I can pull info that a cell doesn't have a formula  but created a work around.
Status = B, Task State < Complete
shows tasks with a state of anything other than Complete and therefore there's no formula in that cell.

If you enter the formula and set it as a column formula, you shouldn't have to worry about any rows missing the formula.

Hello @Paul Newcome,
Thank you for your suggestion. It gave me the impetus to get my formula to work for a column formula.
=IF([% Complete]@row = 1, "Complete", IF([% Complete]r@ow = 0, "Not Started", IF([N/A / On Hold]@row = 1, "On Hold", "In Progress")))
May I ask a follow up? The first row on my sheet has Information in row such as IF NEEDED, ADMIN ONLY, REQUIRED. However, when I make my column formula it takes over my 1st row and I am unable to change it back to the label I need it to be. Do you have any suggestions for that?
Thank you,
Melitta

You would need to change the name of the column. Once a column formula is set, it will be populated in EVERY cell within that column.

If you have a row # column you can add to the formula to check the row # and if it is row # 1 ="ADMIN".
An example for getting row numbers. See below:
 LINEID: SYSTEM AUTO NUMBER
 ROW#: =MATCH([Row ID]@row, [Row ID]:[Row ID], 0
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.9K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.6K Ideas & Feature Requests
 56 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!