+ Reply to Thread
Results 1 to 5 of 5

Google Sheets - Min Date and Cohort formulas not working

  1. #1
    Registered User
    Join Date
    09-23-2015
    Location
    England
    MS-Off Ver
    Excel 16.41 for Mac
    Posts
    21

    Google Sheets - Min Date and Cohort formulas not working

    Hi

    I have a Google sheet which collects Shopify data and a seperate tab (AutoManipulatedAPIData) which lifts the same data and prescribes cohorts, ages, LTV to each transaction. I can get 99% of it to work but the Min Date and Cohort dates (all flagged yellow) dont work.

    https://docs.google.com/spreadsheets...#gid=972258558

    All help much appreciated

  2. #2
    Valued Forum Contributor
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    863

    Re: Google Sheets - Min Date and Cohort formulas not working

    was this problem not already solved by the solutions already provided to you?

    see your existing post:
    https://www.excelforum.com/for-other...one-wonky.html
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

  3. #3
    Registered User
    Join Date
    09-23-2015
    Location
    England
    MS-Off Ver
    Excel 16.41 for Mac
    Posts
    21

    Re: Google Sheets - Min Date and Cohort formulas not working

    The two posts cover different things thanks, the last you helped with was getting the date correctly

  4. #4
    Registered User
    Join Date
    09-23-2015
    Location
    England
    MS-Off Ver
    Excel 16.41 for Mac
    Posts
    21

    Re: Google Sheets - Min Date and Cohort formulas not working

    Quote Originally Posted by janmorris View Post
    was this problem not already solved by the solutions already provided to you?

    see your existing post:
    https://www.excelforum.com/for-other...one-wonky.html
    Hi Jan

    Would you be able to update the yellow cells? The solutions given last time did not correct

    Thanks

  5. #5
    Valued Forum Contributor
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    863

    Re: Google Sheets - Min Date and Cohort formulas not working

    the formulas in the yellow cells dont work because they are the same ones you started with.

    see your other thread where i have given formulas that fix the issue.

    read the conversation in its entirety because i had made corrections.

+ 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: How can I get working formulas to convert into text fields without errors?
    By Kurtsmyname in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 10-01-2021, 07:44 AM
  2. [SOLVED] Google Sheets Chart to Show Rise & Fall of Balances Against Date Not Working
    By djmedzy in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 7
    Last Post: 08-16-2021, 02:28 AM
  3. Google Sheets Formulas - How do I to trap #VALUE & #N/A errors efficiently
    By stewart@itsit.com.au in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-01-2020, 02:50 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. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  6. 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