Hi - I'm trying to create a formula which will allow me to replace a column word if a condition holds true and I can't quite figure it out.
This is what I'm trying to do - If "Start Date" is greater than "Month End Date" then replace the "Accounting Lead" column name with "N/A - Future Expense." I tried a couple of if statements with no luck.
![If Statement.png If Statement.png](https://community.alteryx.com/t5/image/serverpage/image-id/323539i9BE95504B8708E07/image-size/large?v=v2&px=999)