So I want to set up an e-mail template in which I invite someone to a call 2 days from now. So, let's say it's Monday today, I want to make the e-mail say 'Let's have a call on Wednesday'. To do this I've created a formula that has no syntax errors, called 'Day of Meeting', with formula return type set as string. However, it leaves a blank space in my emails.

The formula:

If(Weekday(Adddate(Now(),2,'DAY'))==1,'Monday',(If(Weekday(Adddate(Now(),2,'DAY'))==2,'Monday',(If(Weekday(Adddate(Now(),2,'DAY'))==3,'Tuesday',(If(Weekday(Adddate(Now(),2,'DAY'))==4,'Wednesday',(If(Weekday(Adddate(Now(),2,'DAY'))==5,'Thursday',(If(Weekday(Adddate(Now(),2,'DAY'))==6,'Friday',(If(Weekday(Adddate(Now(),2,'DAY'))==7,'Monday','No day')))))))))))))

Because it does not seem to hold a value, I thought it might have to be implemented into a single line variable. Thus, I created a single line variable , ${Leads.Day}, to have that get information from the formula like so:

${Leads.Day}==If(Weekday(Adddate(Now(),2,'DAY'))==1,'Monday',(If(Weekday(Adddate(Now(),2,'DAY'))==2,'Monday',(If(Weekday(Adddate(Now(),2,'DAY'))==3,'Tuesday',(If(Weekday(Adddate(Now(),2,'DAY'))==4,'Wednesday',(If(Weekday(Adddate(Now(),2,'DAY'))==5,'Thursday',(If(Weekday(Adddate(Now(),2,'DAY'))==6,'Friday',(If(Weekday(Adddate(Now(),2,'DAY'))==7,'Monday','No day')))))))))))))

However, when I try to save this formula it repeatedly comes back with:

" Syntax Error. Check the examples for any functions you're using to see if you formatted them correctly. Make sure your fields are formatted like this: ${Module Name.Field Name}."

Does anybody know how to combat this problem? Any tips or suggestions are very much appreciated. Thanks in advance!