Formula Help!!!

Rebecca Wilhelm

I'm having issues with making this formula work for the RYGB Balls. Any glaring mistakes?

-Green – An open request that was received 1-5 days ago.



-Yellow – An open request that was received 6-10 days ago. 



-Red – An open request that was received more than 10 days ago.



-Blue - Complete



-Blank/No Date - Blank status

=IF(ISBLANK([Information Requested -Auto Filled in Date]1, "", IF(ISDATE([Date Entire Request is Complete/Sent to Law]1, "Blue", IF([Information Requested -Auto Filled in Date]1 >= TODAY(1), "Red", IF([Information Requested -Auto Filled in Date]1 >= TODAY(5), "Yellow", IF([Information Requested -Auto Filled in Date]1 >= TODAY(0),"Green")))))

Thank you!!

L_123

=if(today()-[Information Requested -Auto Filled in Date]1<=5,"Green",if(today()-[Information Requested -Auto Filled in Date]1 <=10,"Yellow",if(isblank([Information Requested -Auto Filled in Date]1),"","Red"

 

Give that a whirl and see if it does what you want.

L_123

Missed your verification sent piece. this formula has it:

 

=IF(ISDATE([Date Entire Request is Complete/Sent to Law]1),"Blue",if(today()-[Information Requested -Auto Filled in Date]1<=5,"Green",if(today()-[Information Requested -Auto Filled in Date]1 <=10,"Yellow",if(isblank([Information Requested -Auto Filled in Date]1),"","Red"

Paul Newcome

Check this thread HERE...