Formulas in Customer Template
SummaryAre formulas allowed in the Upload Customers through Spreadsheet Template
For some of the fields, example, I would like to use the formula =Customers!A6 in the other tabs, instead of asking the customers that same field multiple times. Similarly, I would like to append a sequence number ("-1") to the Account Number make it a Site Number (Site Number = Account Number-1) and by formula it would be =I6&"-1".
Will I be able to upload the customers if there are formulas mentioned above in the spreadsheet?