List fields based on checkbox
Hi, I need a formula field that will list some Years if the corresponding Year checkbox is checked. I'm not sure if this screenshot size is ok or not - it looks super tiny when pasting it. ...
Forum Discussion
Did you try this?
var text FirstYear = If([First Year Ask]=true, ToText([First Year]));
var text SecondYear = If([Second Year Ask]=true, ToText([Second Year]));
var text ThirdYear = If([Third Year Ask]=true, ToText([Third Year]));
var text FourthYear = If([Fourth Year Ask]=true, ToText([Fourth Year]));
var text FifthYear = If([Fifth Year Ask]=true, ToText([Fifth Year]));
List(",", $FirstYear,$SecondYear,$ThirdYear,$FourthYear,$FifthYear)
Here is that: I get an error that says expecting number but found text, for the list.
(I initially typed the field as First Year, but it's actually Year 1, it was my mistake so i just went with it :D)
Is your field a formula numeric or formula text field? Make sure this list formula field is 'Formula Text'.
YES!! That was it! Thank you!!!