+ Reply to Thread
Results 1 to 5 of 5

Google Sheets - SORT formula working but data not visible

  1. #1
    Registered User
    Join Date
    11-29-2013
    Location
    UK
    MS-Off Ver
    Office 365 subscription
    Posts
    49

    Google Sheets - SORT formula working but data not visible

    I'm using a Google sheet to collect answers from Google forms, compare some data and then create a chart.

    The sheet actually works but the issue that I have is that while the =SORT formula works fine (I know it does because the chart takes its data from the results of the formula okay) the cells where it puts its results don't show on screen - it's as if it was white text on a white background.

    Does anyone have any thoughts please on why this might occur?

    I've put a anonymised version here : https://docs.google.com/spreadsheets...it?usp=sharing

    The issues are on the red tab - any input is welcome!

    Thanks in anticipation...

    Ian
    Last edited by Ian99099; 11-30-2020 at 08:44 AM.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2016 primarily
    Posts
    5,195

    Re: Google Sheets - SORT formula working but data not visible

    Without the ability to amend the sheet, I'd have to guess it's formatting that is hiding the contents.
    Rory
    I drink, and I know things

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    8,937

    Re: Google Sheets - SORT formula working but data not visible

    Try scrolling down to row 65

  4. #4
    Valued Forum Contributor hrlngrv's Avatar
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,113

    Re: Google Sheets - SORT formula working but data not visible

    Change your 'Problem Tab'!A1 formula to

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor hrlngrv's Avatar
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,113

    Re: Google Sheets - SORT formula working but data not visible

    If you have a Google account, you could make a copy of the OP's Google Sheets workbook in your own Google Drive and make any changes you want in your copy.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Google Sheets: Merge dynamic ranges automatically (skipping rows without a visible data)?
    By Romkeris in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 15
    Last Post: 06-21-2020, 09:27 AM
  2. Replies: 4
    Last Post: 06-19-2020, 07:37 AM
  3. [SOLVED] Google sheets: Transpose function not working/populating data on other cell
    By rayted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-18-2019, 10:31 AM
  4. Formulas not working with imoprted data from google sheets
    By gassiusmax in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-16-2018, 03:19 PM
  5. Array formula not working in Google Sheets
    By nappy1001 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 04-20-2018, 12:14 PM
  6. Data validation and formula - Google Sheets
    By Human2014 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 8
    Last Post: 04-05-2017, 10:56 AM
  7. From Excel working to Google Sheets no longer working
    By rad1964 in forum Excel General
    Replies: 5
    Last Post: 07-19-2016, 10:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1