Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Kinetic_analytics
11 - Bolide

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

 

 

1 REPLY 1
Matthew
11 - Bolide

if

[ColumnC] = 'Complete'

then

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

else

'0'

endif

Labels
Top Solution Authors