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.
Solved! Go to 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
@patrick_digan I had the wrong column being pulled in. Issue solved.