Title: Excel Functions
Last modified: May 6, 2017

---

# Excel Functions

 *  [lilialves](https://wordpress.org/support/users/lilialves/)
 * (@lilialves)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/excel-functions/)
 * I’m making a function that reads the data registered in the spreadsheet and that
   when selecting the information as approved, the person’s email goes to the next
   tab (approved tab), so I can set up an automatic email in Mailchimp from the 
   emails that was approved tab.
 * The problem is that when the data is sended automatically to spreadsheet by form,
   it ignores the formula and it stops working. Can you help me solve this?
 * The function is this: = IF (MID (lead! M3; 1; 100) = “Yes”; MID (lead! E3; 1;
   100); “”)
    Ps: lead is the name of the tab

The topic ‘Excel Functions’ is closed to new replies.

 * ![](https://ps.w.org/cf7-google-sheets-connector/assets/icon-128x128.gif?rev=
   3232650)
 * [GSheetConnector for CF7 – Connect Contact Form 7 to Google Sheets and Send Form Submissions in Real Time](https://wordpress.org/plugins/cf7-google-sheets-connector/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/cf7-google-sheets-connector/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/cf7-google-sheets-connector/)
 * [Active Topics](https://wordpress.org/support/plugin/cf7-google-sheets-connector/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/cf7-google-sheets-connector/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/cf7-google-sheets-connector/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [lilialves](https://wordpress.org/support/users/lilialves/)
 * Last activity: [9 years, 1 month ago](https://wordpress.org/support/topic/excel-functions/)
 * Status: not a support question