Reporting on cells without formulas

Melitta King

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

Melitta King

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.

Paul Newcome

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

Melitta King

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

Paul Newcome

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.

Leibel S

@Melitta King

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:

1. LINE-ID: SYSTEM AUTO NUMBER
2. ROW#: =MATCH([Row ID]@row, [Row ID]:[Row ID], 0