Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Creating/managing daily task lists

edited 12/09/19 in Archived 2017 Posts

I'm new to SmartSheet, which my team has started using to manage collaborative projects. I'm trying to figure out the easiest/best way to generate a daily task list for myself drawing from the sheets I've created for the multiple projects that I manage.

Your suggestions are most welcome! 


  • I copy rows from my sheets onto ONE sheet that I use as a task list. All the info is then recorded on the other sheets but in one place for me. 

  • I am also trying to figure out the best way to accomplish this, but without manually copying & pasting into another task list sheet.  Wondering if there is a way to use the linked cells feature to do this but haven't been able to figure it out yet.  


  • Si Spence
    Si Spence ✭✭✭✭✭✭

    Just a thought...assuming you have a column on each sheet titled something left 'next steps', then you could add a date column to the sheet called 'donnas tasks'.  Add a date to 'donnas task' only if you have a task to complete by that date.

    Then create a Report 'My Tasks', link this Report to all the sheets on which you have a 'donnas task' column and ask the Report to pick all rows where 'donnas task' contains a date. 

    Not an elegant solution but might work.

  • When I was trying to do this, I added a start date, end date and a target date for the tasks I needed to complete.

    Then I created a report called an Open task report and one called tasks due in next 7 days.  I did this using report builder at the bottom of each sheet.

    I added a screenshot of each report set up.  The first one is open tasks.  The second one is tasks due in the next 7 days.

    Hopefully it will work for you too!


    Take care,




    Open Task Report Parameters.png

    Tasks due in next 7 days.png

This discussion has been closed.