SammyMorey✭

We always only ever used Google Chrome and only had the ONE window open at the time. We found out that we were getting mighty close to the cell limit so we ended up splitting the sheet again and we no longer have the "Aw Snap" issues. We do find that if we get close to the maximum limit doing anything is very slow and it…

In case anyone was looking for an answer when searching this one - it was very simply that we had data mesh's from several sheets. And there was a duplication of the "lookup value" in 2 separate sheets. This means that the cell was constantly being overridden by each sheet back and forward. We were able to fix the…

Sorry all fixed my issue and can not delete my comment - ignore me :)

Hi Andre - I am already using cross sheet index match formulas - but I needed to get the unique Identifier into the sheets I was using to do all the formulas. BUT I worked out I can use an auto number column in the source sheet - then (because I can predict what the auto numbers will be) use those as the unique identifier.…

hey all thanks for your input - We have all the data in "interim" sheets and reports - but unfortunately we actually want a snapshot of the dashboard itself. We have setup outlook reminders for someone in each team to print to a pdf on the last day of the month - but if this falls on a weekend we miss it. :S - be great if…

Hey guys - I spoke with Smartsheet people on this one - and it has to do with other users being in the sheet. Even if they can not move the rows around, if they are in a previous view or order and have not refreshed, if they make a change and then save, their order (the old order) will save over the top of any new version…