Tuesday, December 4, 2012

Google Drive Spreadsheet Defect

Formula does not update when moving a column on another sheet

Example formula on Sheet2:
=DAYS360(B1, MAX(Sheet1!A:A))

After moving column A, formula becomes:
=DAYS360(B1, MAX({}))

Not a major problem since I only have one cell to update but this may be an issue if more formulas are dependent on the sheet.

Found: 12/4/2012

No comments:

Post a Comment