Excel Functions

  • lilialves

    (@lilialves)


    9 years, 1 month ago

    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.