Coverting an excel formula to Alteryx

Question

I am having trouble converting the below excel formula to a formula in Alteryx. Can anyone help?

=IF(AJ181>(TODAY()),"IN-FLIGHT",IF(AG181="WRITING","PRE-RFP WORK",IF(AQ181="UNREAD", "DTQ",IF(AQ181="DECLINED","DTQ",IF(AQ181="IGNORED","DTQ",IF(AQ181="POSTED","QUOTED",IF(AQ181="ABANDONED","DTQ","***REVIEW")))))))

Luke_C · Accepted Answer

Hi @rread

Something like the below should work, would need to replace the column names based on your dataset.

If [AJ] > DateTimeNow()
Then 'IN-FLIGHT'
Elseif [AG] = 'Writing'
Then 'PRE-RFP WORK'
Elseif [AQ] in('UNREAD','DECLINED','IGNORED','ABANDONED')
Then 'DTQ'
Elseif [AQ] = 'POSTED'
Then 'QUOTED'
Else 'REVIEW'
Endif