Please advise if you can help me convert this Excel formula to a Smartsheet formula.
I keep getting #UNPARSEABLE when using the following formula:
=IF([CUSTODY DATE]7>1/1/2000,IF($MILEAGE$2<=([CUSTODY DATE]7+2),(125+75+40),($MILEAGE$2-([CUSTODY DATE]7+2)*15+(125+75+40)), )
I was told to make this correction, however, I am still having the same trouble:
Based on the IF formula provided, $ MILEAGE $ 2 seems to be causing the #UNPARSEABLE error. If this is a column, you will need to change it to [MILEAGE](row number or @row).
Any help is appreciated.