Coverting an excel formula to Alteryx

[rread]

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 solution]

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

[rread]

Lifesaver! Thank you Luke.