+ Reply to Thread
Results 1 to 1 of 1

Auto delete cell info after fixed time period

  1. #1
    Registered User
    Join Date
    06-23-2020
    Location
    Hilton, South Africa
    MS-Off Ver
    2016
    Posts
    1

    Auto delete cell info after fixed time period

    Hey everyone,

    My first post here, I would like to say that I am by no means a programming well.. anything and that I have really tried to sort this out myself but I am now truly lost.

    We run a school and are trying to develop an easy to follow task completion system for our staff to follow. I've checked out paid options like Monday.com, Asana etc but they are both expensive and more complicated than what our needs dictate.

    I therefore created a google sheet, (I tried to add in the shared link here but the forum wont let me post it as I'm a new member, I have therefore added in a pic) using one of the templates available from Google. I've created a separate one for each of our staff membersand its more or less perfect. We protect all the ranges with the exception of the little tick boxes and it's easy to track and see who's done what and when as they (the sheets) are obviously centrally located on Google and can be pinned in a browser or downloaded as mobile screen shortcut. My only issue is creating tasks that need to be repeated on a regular bases ie, a weekly task that has to happen every Monday. Going through each sheet to untick each task for each staff member has become very time consuming. I've done a fair amount of research and tried my hand at setting up the macros etc but keep on screwing it all up.

    I'd like to know if there is a way I can just get the 'ticks' in the completed tasks to clear at preset intervals? I know its possibly to do it daily. I have a new tab allocated at the bottom of the sheet for each type of interval (daily, weekly, monthly). The general tab is there for once off tasks that need to be completed.

    Can any one help or advise me on how to set up the above system? I'd be most grateful, I did go through the following thread but got pretty lost (won't let me post as I'm a new member).

    Many thanks,
    Rob
    Attached Images Attached Images

+ 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. [SOLVED] Auto delete info of a cell after 24 hours
    By Santy4tas in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-13-2020, 08:40 PM
  2. [SOLVED] Formula/method to sort by specific time period within date+time ranges in cell
    By mikeskins84 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-13-2018, 01:12 PM
  3. Delete rows after a certain time period has passed
    By JRC1 in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 03-02-2017, 05:57 AM
  4. [SOLVED] Complicated:Calculate time period based on no. of units sold + fluctuations within period
    By omaha.crab in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2012, 03:04 AM
  5. Alternating a shape's fill colour for a fixed period of time
    By deadlyduck in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-06-2010, 05:16 AM
  6. [SOLVED] drawdown at fixed rate over set period from investment at fixed %
    By jamook in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-28-2005, 07:00 PM
  7. [SOLVED] Auto Update after certain time period (60 sec)
    By mrdelia in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 07-10-2005, 01:05 PM

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