***This was posted in another Zone (MS Excel) apologies for any duplication****
I have a spreadsheet which pulls customer data from goldmine using the following syntax.
This particular syntax pulls the phone number for the customer.
My users leave this spreadsheet open all day and flick to through different cases. Sometimes the phone1 field is blank, when this occurrence happens, the previously viewed goldmine record phone number remains in view on the spreadsheet. I would like the formula to check the Phone 1 field and if its blank, then clear the cell in goldmine rather than leaving the previous phone number in view.