I have a category field named "Nights Available" with the days of week written out.
I am trying to use a calculation field to convert this text string to a number. All days of the week equal 1.
I will use another calculation field (or Globiflow) to add these values together in a later step.
If "Nights Available" equals "Monday" and "Thursday" the total number value would equal 2.
I have been unsuccessful doing this so far, can anyone help?
Please sign in to leave a comment.