Forum Discussion

marietuttle1973's avatar
marietuttle1973
Brass Contributor
Jan 02, 2025

Excel Formula

I created an excel workbook with multiple worksheets that all have formulas.  I made sure everything worked, then uploaded to Google Sheets.  Now some of the formulas are not working.  Some are, but ...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Jan 03, 2025

We'd have to know which formulas don't work

marietuttle1973's avatar
marietuttle1973
Brass Contributor
Jan 06, 2025

Is there a way I can email you the spreadsheet so you can see?  Basically, only the information in the first sheet works in Google sheets and that is information that is typed in manually.  The master sheet contains all the customer data, which should then feed over to the other sheets depending on what is in a specific column. For example the master sheet has all customer data and each customer has a type.  There is a worksheet for each type and once information is enterd on the master it should automatically go to the correct worksheet based on type.

If customer on Master has type of Lead, then their information should auto populate on the worksheet that is called Lead.

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jan 06, 2025

    For example:

    =IFERROR(ARRAYFORMULA(FILTER(Master!A2:I1000, Master!B2:B1000="New Install")), "")

    and similar for the other sheets.

Resources