Skip to main content
Question

Getting started question on formula fields

  • February 17, 2019
  • 0 replies
  • 25 views

I'm a beginner. I want to create a formula field that will take the selected text from a multiple choice field and convert it into $. This is for a student enrollment app where parents can select 5 full day, 3 full day, etc. enrollment options. Each option has its own fee.  I have created a formula field: If([Enrollment Type]="5 Full Day",360). Clearly it doesn't work. I want the result to be $360 if 5 Full Day is the enrollment type (that's the field name) selected.
This topic has been closed for replies.

Forum|alt.badge.img+12
  • Registered
  • February 17, 2019
When building an IF statement you also need an "else" condition.

If([Enrollment Type]="5 Full Day",360,null)

if "enrollment type" is equal to "5 Full Day", then 360, otherwise zero