case formula returning one value

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
Newbie here! Probably a silly error on my part but...

I am trying to create a formula in the field "Mileage Cost" that will look at a date in the field "Date", find what year "Date" contains, and then multiply by a different number based on that year, then return that product back into the field "Mileage Cost". Currently, every "date" selected is returning a value of "2016" in "Mileage Cost."


Any ideas would be appreciated!

Photo of Marisa L

Marisa L

  • 100 Points 100 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of Chayce Duncan

Chayce Duncan

  • 1,152 Points 1k badge 2x thumb
You don't need to repeat year([Date]) multiple times. 

A simple 

2015,result 1,
2016, result 2,
2017, result 3,
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,478 Points 50k badge 2x thumb
Ya, that formula is a bit muddled.  You are over complicating it.

Photo of Marisa L

Marisa L

  • 100 Points 100 badge 2x thumb
Thank you both! Works great!