Help with IF formula

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • Answered
I need help with an If formula. I'm trying to say: If the "type of record" field contains the word "actual", add cost and qty fields together. Otherwise leave blank.
Photo of Emily Hill

Emily Hill

  • 172 Points 100 badge 2x thumb

Posted 8 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,546 Points 50k badge 2x thumb
IF(Contains([type of record], "actual"), [cost] + [qty])
Photo of Emily Hill

Emily Hill

  • 172 Points 100 badge 2x thumb

Thank you so much! :)