+ Reply to Thread
Results 1 to 2 of 2

Google Sheets: Synchronization and maintain action log maintain

  1. #1
    Registered User
    Join Date
    02-15-2017
    Location
    Sri Lanka
    MS-Off Ver
    2007
    Posts
    1

    Post Google Sheets: Synchronization and maintain action log maintain

    Hi,
    In our company, we use Google Sheets to maintain action logs.
    We have several meetings and we have several action logs based on the topics.
    In this action log, some actions are assigned to team members.
    But it is hard to visit all available action logs to find the responsible/assigned actions for me and update my status.
    What is the best way to synchronize these action logs and develop a single sheet for an individual team members?
    Need your support to solve this

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,137

    Re: Google Sheets: Synchronization and maintain action log maintain

    "synchronize" implies a 2 way update of data, for that you will require Apps Scripts.

    If you really just need a master list to separate data out to individuals, then you may be able to do this with filter() and importrange().
    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]

+ 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. Copy certain sheets to a new workbook and maintain reference formulas
    By okela in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-24-2020, 09:34 AM
  2. Replies: 1
    Last Post: 01-15-2019, 03:18 AM
  3. Maintain Formatting when referencing cells from other sheets
    By joninmal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-11-2010, 05:10 AM
  4. Autofilter Lists across Multiple Sheets, Maintain Correct Referenc
    By EDSTAFF in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-14-2005, 11:30 AM
  5. Maintain format between sheets
    By pec2b0 in forum Excel General
    Replies: 2
    Last Post: 03-12-2005, 02:58 PM
  6. VB, copying 2 sheets to a new book while maintain relationships
    By delly in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-08-2005, 06:18 AM

Tags for this Thread

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