Hello All,

    After failing in my google searches I figured I will ask for help. In the list I have the two collams I want to use to format a thrid. 1. called Current Suspense Date ([$Current_x0020_Suspense_x0020_Dat] in JASON ) which is a date only collum & [$Complete] which is a Yes/No collum.

    I need to figure out how to do the folowing in order and stop once an :

If [$Complete] == Yes && [$Current_x0020_Suspense_x0020_Dat] is more than 7 days from today, format green fill.If else [$Current_x0020_Suspense_x0020_Dat] 7 or less days in the future fill yellowIf else [$Current_x0020_Suspense_x0020_Dat] is today or in the past fill Red

​Hello All,    After failing in my google searches I figured I will ask for help. In the list I have the two collams I want to use to format a thrid. 1. called Current Suspense Date ([$Current_x0020_Suspense_x0020_Dat] in JASON ) which is a date only collum & [$Complete] which is a Yes/No collum.    I need to figure out how to do the folowing in order and stop once an :If [$Complete] == Yes && [$Current_x0020_Suspense_x0020_Dat] is more than 7 days from today, format green fill.If else [$Current_x0020_Suspense_x0020_Dat] 7 or less days in the future fill yellowIf else [$Current_x0020_Suspense_x0020_Dat] is today or in the past fill Red  Read More

​