Trying to make a report field that looks into Actual Date first. If Actual Date is blank, it will look into Forecast Date. If Forecast date is blank, look into Formula Date. I was originally thinking using NZ() but it only works with 2 variables. My logic should be something like
if([Actual Date] =""), [Forecast Date]
else if([Forecast Date] = "", [Formula Date])
So in priority, checks Actual, if Actual blank, use Forecast, if Forecast blank, use formula. Just not so sure how to put that into logic formula that quickbase can use. Any help is appreciated.