Formula Field Unable to Process Past \
I am trying to create a formula text field and keeping getting an error saying that there are characters outside of the formula. I am trying to create a file path to pass through Zapier to our cloud ...
Forum Discussion
The \ character has a special meaning in a formula, used when you really do want, say to include a quote inside quotes.
Can you try this.While you see \\ the result should just be \
List("",
[Term Slot - Term Awards: Grant - Program Year - Fiscal Year],
"\\Year Long\\",
[Common Person ID# - Current Member Term: Term Award - Grant Name],
"\\",
[Term Slot - Person - Contact: Legal Last Name],
", ",
[Term Slot - Person - Contact: Legal First Name],
"\\",
[Term Slot - Person - Contact: Legal Last Name],
", ",
[Term Slot - Person - Contact: Legal First Name],
" PRU ",
Case([Email Subject],"January", "January","February", "February","March", "March","April", "April","May", "May","June", "June","July", "July","August", "August","September", "September", "October", "October","November", "November","December", "December"),
".pdf")
Can you try this.While you see \\ the result should just be \
List("",
[Term Slot - Term Awards: Grant - Program Year - Fiscal Year],
"\\Year Long\\",
[Common Person ID# - Current Member Term: Term Award - Grant Name],
"\\",
[Term Slot - Person - Contact: Legal Last Name],
", ",
[Term Slot - Person - Contact: Legal First Name],
"\\",
[Term Slot - Person - Contact: Legal Last Name],
", ",
[Term Slot - Person - Contact: Legal First Name],
" PRU ",
Case([Email Subject],"January", "January","February", "February","March", "March","April", "April","May", "May","June", "June","July", "July","August", "August","September", "September", "October", "October","November", "November","December", "December"),
".pdf")
Yes, that worked perfect. Thank you!