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
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 like it to automatically copy that row from the source sheet to the destination sheet. The…
How can I add rows from one sheet to another automatically?
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 matching PO number to a PO on the PO sheet, the PO amount would decrease by the invoice…
Date Added Field - Auto Fill
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" chart in Excel, with other metrics, to track my personal efficiency.
Reports and Pagination
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 switch the target to a report, only 100 rows will sync. When I switched to looking at a…
Creating a sheet for duties ~ limiting the participation.
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 you!
How to avoid tasks being split across days
* 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!
LOOKUP() Function
Hi Team, In regards to the LOOKUP() function can the lookup_value be a cell reference instead of a "text" search?
Return a value based on a date
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.
Create report based on parent row
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 smith, golden delicious and honey crip. Another parent row is pears. Children rows to "pears" are…
Resource management
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, so can we assign 3 hours for P1, 3 Hours to p2 and 2 hours for p3 daily.