Report with What and When requirements

Elisabeth ✭✭
edited 12/09/19 in Formulas and Functions

Hello community,

I need your help on this report. The solution is probably very easy, I just cannot get my head around it.

I have a project plan with one column "Flag" (lines can be flagged with the little red flag) and a column with the finish date. Now I want to create a Report, which shows me all "flagged" tasks, as well as all tasks, which are late in the project plan.

Within the report builder, I have selected the requirements WHAT and WHEN (see screenshot). However, the report I get only shows flagged tasks, when they are late, not those which are on time. 

What do I do wrong?

THANKS a lot for your help. :)



Annotation 2019-11-20 164452.jpg



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!