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.

Archived 2016 Posts

Archives for September 2016

Discussion List

  • Copy Rows Between Sheets Based on Checkbox
    In Archived 2016 Posts
    I am trying to create a calendar or events based off a master list of events on another sheet.   The source sheet is a master list of all possible events. That sheet contains a column of check boxes. When a checkbox is checked I would li…
    59 4
    Closed 59 views 4 comments Most recent by John Simon Archived 2016 Posts
  • How can I add rows from one sheet to another automatically?
    In Archived 2016 Posts
    I am trying to create a PO / Invoice tracking system for my team. One sheet has all the blanket PO #'s and amounts and the other has all the invoices that are tied to each PO.   So if an invoice is added to the invoice sheet that has a m…
    161 2
    Closed 161 views 2 comments Most recent by J. Craig Williams Archived 2016 Posts
  • Date Added Field - Auto Fill
    In Archived 2016 Posts
    Is there a way to create a field that auto fills with today's date every time a row is added to the sheet?   My end-goal is to use the Card-view to organize my tasks, and the auto-date to export this list and create a "burn down&quo…
    2926 3
    Closed 2.9K views 3 comments Most recent by Heidi Decker Archived 2016 Posts
  • Reports and Pagination
    In Archived 2016 Posts
    Hi!   I've written a google script that mirrors a smartsheet - it checks hourly and syncs the google sheet to reflect the latest info in smartsheets.  It works great with sheets, and all of the rows populate correctly.  However, when I sw…
    119 3
    Closed 119 views 3 comments Most recent by Benjamin Walker Archived 2016 Posts
  • Creating a sheet for duties ~ limiting the participation.
    In Archived 2016 Posts
    We are in need of a large number of volunteers to assist at an event.  We want them to sign up for specific days/times.  Some of the positions need a specific number of people.  Can I close the option once that number is reached?  Thank yo…
    3 2
    Closed 3 views 2 comments Most recent by Shaine Greenwood Archived 2016 Posts
  • How to avoid tasks being split across days
    In Archived 2016 Posts
    * Hi * * with a sheet that has dependencies enabled, is it possible to avoid having an activity (e.g. a training course, lasting say 3 hours) being scheduled across 2 days (or a weekend)?   Thank you!    
    3 1
    Closed 3 views 1 comment Most recent by Shaine Greenwood Archived 2016 Posts
  • LOOKUP() Function
    In Archived 2016 Posts
    Hi Team, In regards to the LOOKUP() function can the lookup_value be a cell reference instead of a "text" search?
    2 2
    Closed 2 views 2 comments Most recent by Mark Milham Archived 2016 Posts
  • Return a value based on a date
    In Archived 2016 Posts
    Hi there everyone, I have posted before but am still stuck.   https://app.smartsheet.com/b/publish?EQBCT=5b60441a73dc4bfe9c4e77977e0cce7c   Hope this is helpful and clear.
    57 6
    Closed 57 views 6 comments Most recent by Benjamin Walker Archived 2016 Posts
  • Create report based on parent row
    In Archived 2016 Posts
    Thanks in advance for any advice. I appreciate your time and expertise. I would like to create a reports that include all children of a parent row. For example, the parent row is "apples", the children rows are gala, granny smit…
    cm Profile Photo cm
    598 3
    Closed 598 views 3 comments Most recent by J. Craig Williams Archived 2016 Posts
  • Resource management
    In Archived 2016 Posts
    Can we set working hours for perticular project to each resource associated? As each resource may works on multiple project daily, we want to assign working hours for each project i.e. if resource R1 is working 3 diffrent project parallely…
    2 3
    Closed 2 views 3 comments Most recent by Shaine Greenwood Archived 2016 Posts