I need this formula below to show not only blank values for lastbuildorship but also put Y if the lastbuildorship is older then 3 years old. So all 3 rules have to work together: GlobalQ=0, lastbuildorship is blank or older then 3 years to receive Y. Please advise whats wrong with my formula?
IF(AND(#GlobalQ==0; AND(ISBLANK(#Lastbuildorship); #Lastbuildorship<ADDTODATE(TODAY();"3y"))); "Y"; "N")
Please sign in to leave a comment.