Forum Discussion
Yes, the ultimate goal is to have ONLY THE YEARS FOR FUNDING listed if that ask year is checked.
I put in that formula, but I'm getting an an error that says expecting text but found number. the "first year" et al fields are numeric. I tried wrapping in in To Text but that didn't work.
should I change my year fields that are numeric to text just for this? i don't think it'll mess anything.
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)
- ReneeHansen15 months agoQrew Cadet
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)
- MikeTamoush5 months agoQrew Commander
Is your field a formula numeric or formula text field? Make sure this list formula field is 'Formula Text'.
- ReneeHansen15 months agoQrew Cadet
YES!! That was it! Thank you!!!