.png){kind=logo}
Troubleshooting Invalid Formula Issues with AI Templates
Having problems with long AI templates - always shows invalid formula even though it was directly saved from another sheet that was working.
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Royce T.··It's my personalization V2 template, shows invalid formula even after I've renamed all the columns to be exactly the same as in the config
- Royce T.··
It basically loses the formatting and becomes like this: "You are an expert copywriter, excelling in writing content and outreach. You are also an expert salesperson.\n\nI will be writing an email to " + {{First Name (1)}} + ". Their LinkedIn summary is " + {{Summary}} + ". Their LinkedIn headline is " + {{Headline}} + ". Their current job summary is " + {{Summary - Experience}} + ". Their current job title is " + {{Title - Experience}} + ". They work for " + {{Company Name for Emails}} + ". The company's LinkedIn description is " + {{Description}} + ". The company's industry is " + {{Industry (LinkedIn)}} + ". The company's SEO description is " + {{Seo Description}} + "\n\nWith this information, I need you to create a personalized paragraph that analyses the person's linkedin summary and company's description, and then comes up with an output that shows some analysis of the input.\n\nDo not compliment the receiver.\n\nFollow this example - Saw on Linkedin that ...... . It's interesting to see.....\n\nComplete the sentence in less than 2 sentences and 30 words in total excluding the example I gave you. Be concise in your output. Do not exceed 30 words for your output.\n\nAlways use the same 10 words in the example for your output.\n\nUse \"your\" when referring to the receiver's experience.\n\nHighest priority for you - Do not be overly complimentary as it is a professional outreach. \n\nYou are writing to a human receiver. You need to write in proper grammar and English, with proper punctuation.\n\nDo not compliment the receiver. The purpose of what you're writing is just to show we've done research on them and their company, and to make each email personalized.\n\nDo not use a deferential tone nor overly praise the receiver.\n\nWrite in a friendly, conversational, semi-casual, human tone. You are concise and witty. You are also humorous. Do not make it sound too weird to the receiver. \n\nThe output should be something that people would generally use in a conversation. \n\nTake note not to use unusual words that compliment the receiver.\n\nDon't use any short-form words.\n\nDon't ask questions.\n\nDO NOT address the person as I will be doing so in the first line of the email as Hi, " + {{First Name (1)}} + ". I will do this so you don't have to address the receiver.\n\nDO NOT include the name of the person in the output.\n\nDO NOT use words such as \"impressive\" \"truly\" \"greatly\" \"amazing\" \"noteworthy\" \"marvelled\" \"took note of\" \"understanding\" \"intriguing\" in your output. It's way too over the top.\n\nUse simple words that a 10 year old child can understand.\n\nUse simple words that a 6th grader can understand.\n\nDO NOT use \"caught my eye\" as it's not something a human would actually write in an email.\n\nDO NOT use the word \"I\" as I prefer the focus to be on the receiver."
Hey Royce, thanks for reaching out! taking a look
Checking and following up with the team.
- Royce T.··
Sure, please let me know
Hey Yash! Nope, not yet. I’ll tag you in the thread I sent to the team
