Syntax error in Numbers spreadsheet.
I have a Numbers spreadsheet that was imported from an excel spreadsheet that comes up with this error message “The formula contains a syntax error”.
the formula is to take the date from column B Row Number and insert that date into the Transaction sheet on the same line as the column that has the date you want to insert in the transaction sheet.
The Transaction sheet has tow lines instead of one line for each entry. It is a financial register and transaction record spreadsheet. The difference between the excel sheet and the numbers sheet is, excel has both sheets on the same page and numbers has it on two pages. With that being on different pages, you can’t just click on the different cells to insert a formula because when you go to t he second sheet the edit formula disappears.
So the formula that comes up on my transaction sheet is:
IF(Register::Table 1::B9<1÷1÷16,"-",Register::Table 1::B9)
The table line changes for each entry.
Now my question is: How can I change the formula so I get the date from the Register sheet to enter the date into my Transaction sheet.
This spreadsheet was designed at our national organization for use by the Treasurers for our chapters accounting of chapters funds.
I am going to try and put a photo of the spreadsheet and the Transaction sheet. You can see the error in the Transaction Register photo.
iMac 21.5″, macOS 10.13