=IF(C2="Complete", TEXT(A2,"YYYY")&"-"&TEXT(A2,"MM"),0)

[Kinetic_analytics]

How to convert =IF(C2="Complete", TEXT(A2,"YYYY")&"-"&TEXT(A2,"MM"),0) to Alteryx formula.

[Matthew · Accepted solution]

if

[ColumnC] = 'Complete'

then

tostring(DateTimeFormat([ColumnA],'%Y-%m'))

else

'0'

endif