Spreadsheet: 725512d1616708775-if-function-returning-false-copy-of-stack-model-gantt-chart-help
Sheet: Example

 |  |  |  | 2020-01-06 00:00:00
 |  |  |  | 1
 |  |  |  | 2020-01-01 00:00:00 |  |  |  | 2020-02-01 00:00:00 |  |  |  | 2020-03-01 00:00:00 |  |  |  |  |  | 2020-04-01 00:00:00
Target at Budget | Current Target | Longstop to hit plan
2020-01-10 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00
2020-02-20 00:00:00 | 2020-02-20 00:00:00 | 2020-04-01 00:00:00
2020-05-01 00:00:00 | 2020-02-01 00:00:00 | 2020-05-01 00:00:00
Target at Budget | Current Target | Longstop to hit plan
 | 2020-01-10 00:00:00
2020-01-10 00:00:00 | 2020-01-10 00:00:00 | 2020-02-20 00:00:00
2020-01-10 00:00:00 | 2020-03-01 00:00:00
 |  |  |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  |  |  | [NAME]
 |  |  |  |  |  | All Blank = Blank |  |  |  | IF(AND($A12="",$B12="",$C12=""),"",NEXT
 |  |  |  |  |  | A Populated, B&C Blank |  |  |  | IF(AND($A12<>"",$B12="",$C12=""),BUDGETIF |  |  |  |  |  | IF(AND($A12<>"",$B12="",$C12=""),IF(OR(AND($A12<E$5+7,$A12>E$5),E$5=$A12),"Budget",""))
 |  |  |  |  |  | B Populated, A&C Blank |  |  |  | IF(AND($A12="",$B12<>"",$C12=""),TARGETIF |  |  |  |  |  | IF(AND($A12="",$B12<>"",$C12=""),IF(OR(AND($B12<E$5+7,$B12>E$5),E$5=$B12),"Target",""))
 |  |  |  |  |  | C Populated, A&B Blank |  |  |  | IF(AND($A12="",$B12="",$C12<>""),LONGSTOPIF |  |  |  |  |  | IF(AND($A12="",$B12="",$C12<>""),IF(OR(AND($C12<E$5+7,$C12>E$5),E$5=$C12),"Longstop",""))
 |  |  |  |  |  | A & B Populated Matching, C Blank |  |  |  | IF(AND($A12<>"",$B12<>"",$C12=""),BUDGET+TARGETIF |  |  |  |  |  | IF(AND($A12<>"",$B12<>"",$C12="",$A12=$B12),IF(OR(AND($A12<E$5+7,$A12>E$5),E$5=$A12),"Budget+Target",""))
 |  |  |  |  |  | A & B Populated, C Blank |  |  |  | IF(AND($A12<>"",$B12<>"",$C12=""),BUDGETIF, TARGETIF |  |  |  |  |  | IF(AND($A12<>"",$B12<>"",$C12="",$A12<>$B12),IF(OR(AND($A12<E$5+7,$A12>E$5),E$5=$A12),"Budget",IF(OR(AND($B12<E$5+7,$B12>E$5),E$5=$B12),"Target","")))
 |  |  |  |  |  | A & C Populated Matching, B Blank |  |  |  | IF(AND($A12<>"",$B12="",$C12<>""),BUDGET+LONGSTOPIF |  |  |  |  |  | IF(AND($A12<>"",$B12="",$C12<>"",$A12=$C12),IF(OR(AND($A12<E$5+7,$A12>E$5),E$5=$A12),"Budget+Longstop",""))
 |  |  |  |  |  | A & C Populated, B Blank |  |  |  | IF(AND($A12<>"",$B12="",$C12<>""),BUDGETIF, LONGSTOPIF |  |  |  |  |  | IF(AND($A12<>"",$B12="",$C12<>"",$A12<>$C12),IF(OR(AND($A12<E$5+7,$A12>E$5),E$5=$A12),"Budget",IF(OR(AND($C12<E$5+7,$C12>E$5),E$5=$C12),"Longstop","")))
 |  |  |  |  |  | B & C Populated Matching, A Blank |  |  |  | IF(AND($A12="",$B12<>"",$C12<>""),TARGET+LONGSTOPIF |  |  |  |  |  | IF(AND($A12="",$B12<>"",$C12<>"",$B12=$C12),IF(OR(AND($B12<E$5+7,$B12>E$5),E$5=$B12),"Target+Longstop",""))
 |  |  |  |  |  | B & C Populated, A Blank |  |  |  | IF(AND($A12="",$B12<>"",$C12<>""),TARGETIF, LONGSTOPIF |  |  |  |  |  | IF(AND($A12="",$B12<>"",$C12<>"",$B12<>$C12),IF(OR(AND($B12<E$5+7,$B12>E$5),E$5=$B12),"Target",IF(OR(AND($C12<E$5+7,$C12>E$5),E$5=$C12),"Longstop","")))
 |  |  |  |  |  | All Populated Matching |  |  |  | IF(AND($A12<>"",$B12<>"",$C12<>""),BUDGET+TARGET+LONGSTOPIF |  |  |  |  |  | IF(AND($A12<>"",$B12<>"",$C12<>""),IF(AND($A12=$B12,$B12=$C12,$A12=$C12),IF(OR(AND($B12<E$5+7,$B12>E$5),E$5=$B12),"Budget+Target+Longstop","")))
 |  |  |  |  |  | A & B Populated Matching, C Not |  |  |  | IF(AND($A12<>"",$B12<>"",$C12<>""),BUDGET+TARGETIF, Longstopif |  |  |  |  |  | IF(AND($A12<>"",$B12<>"",$C12<>""),IF(AND($A12=$B12,$B12<>$C12),IF(OR(AND($A12<E$5+7,$A12>E$5),E$5=$A12),"Budget+Target",IF(OR(AND($C12<E$5+7,$C12>E$5),E$5=$C12),"Longstop",""))))
 |  |  |  |  |  | A & C Populated Matching, B Not |  |  |  | IF(AND($A12<>"",$B12<>"",$C12<>""),BUDGET+LONGSTOPIF, [NAME] |  |  |  |  |  | IF(AND($A12<>"",$B12<>"",$C12<>""),IF(AND($A12=$C12,$C12<>$B12),IF(OR(AND($A12<E$5+7,$A12>E$5),E$5=$A12),"Budget+Longstop",IF(OR(AND($B12<E$5+7,$B12>E$5),E$5=$B12),"Target",""))))
 |  |  |  |  |  | B & C Populated Matching, A Not |  |  |  | IF(AND($A12<>"",$B12<>"",$C12<>""),TARGET+LONGSTOPIF, Budgetif |  |  |  |  |  | IF(AND($A12<>"",$B12<>"",$C12<>""),IF(AND($B12=$C12,$C12<>$A12),IF(OR(AND($B12<E$5+7,$B12>E$5),E$5=$B12),"Target+Longstop",IF(OR(AND($A12<E$5+7,$A12>E$5),E$5=$A12),"Budget",""))))
 |  |  |  |  |  | All Populated not Matching |  |  |  | IF(AND($A12<>"",$B12<>"",$C12<>""),BUDGETIF, TARGETIF, Longstopif |  |  |  |  |  | IF(AND($A12<>"",$B12<>"",$C12<>""),IF(AND($B12<>$C12,$C12<>$A12),IF(OR(AND($A12<E$5+7,$A12>E$5),E$5=$A12),"Budget",IF(OR(AND($B12<E$5+7,$B12>E$5),E$5=$B12),"Target",IF(OR(AND($C12<E$5+7,$C12>E$5),E$5=$C12),"Longstop",""))))
 |  |  |  |  |  | Budgetif | IF(OR(AND($A12<E$5+7,$A12>E$5),E$5=$A12),"Budget",""
 |  |  |  |  |  | [NAME] | IF(OR(AND($B12<E$5+7,$B12>E$5),E$5=$B12),"Target",""
 |  |  |  |  |  | Longstopif | IF(OR(AND($C12<E$5+7,$C12>E$5),E$5=$C12),"Longstop",""
 |  |  |  |  |  | Budget+Targetif | IF($A12=$B12,IF(OR(AND($A12<E$5+7,$A12>E$5),E$5=$A12),"Budget+Target",""))
 |  |  |  |  |  | Budget+Longstopif | IF($A12=$C12,IF(OR(AND($A12<E$5+7,$A12>E$5),E$5=$A12),"Budget+Longstop",""))
 |  |  |  |  |  | Target+Longstopif | IF($B12=$C12,IF(OR(AND($B12<E$5+7,$B12>E$5),E$5=$B12),"Target+Longstop",""))
 |  |  |  |  |  | Budget+Target+Longstopif | IF(AND($A12=$B12,$B12=$C12,$A12=$C12),IF(OR(AND($B12<E$5+7,$B12>E$5),E$5=$B12),"Budget+Target+Longstop",""))