Conditional Formula

[MoeShow]

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. 

[patrick_digan · Accepted solution]

@MoeShow Try a formula like this for the Accounting Lead field:

If [Start Date] > [Month End Date] then "N/A - Future Expense" Else [Accounting Lead] endif

[MoeShow]

@patrick_digan I had the wrong column being pulled in. Issue solved.