# Formulas

Options
edited 12/09/19

I am trying to write an IF statements that allows me to set either an up, sideways or down arrow based on the the difference between two dates. I have found many example and have tried to reverse engineer them however I am not having any luck

Basically if the two date fields when subtracted = a number less then or = 7 then display Up arrow

OR if the two date fields when subtracted = a number between 8 and 12 then display Sideways arrow

OR if the two date fields is greater than 13 then display Down Arrow

Here is what I have but its indicating Unparseable. Not sure if I have ( ) in the right place. Any help would be great,

=IF([End Date]1 - [Base Line END Date]1 >= 1, [End Date]1 - [Base Line END Date]1 <= 7, “Up”, IF([End Date]1 - [Base Line END Date]1 >= 8, [End Date]1 - [Base Line END Date]1 <= 12, “Sideways”,“Down”))

Tags:

• Options

Actually I believe this Works for me:

=IF([End Date]1 - [Base Line End Date]3 <= 7, “Up”, IF([End Date]1 - [Base Line End Date]1 > 30, “Down”, “Sideways”))

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!