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...
see more 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...
see more 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,...
see more 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...
see more 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!...
see more
Thank you!
...
see more
Hi Team, In regards to the LOOKUP() function can the lookup_value be a cell reference instead of a "text" search?
Hi there everyone,
I have posted before but am still stuck.
https://app.smartsheet.com/b/publish?EQBCT=5b60441a73dc4bfe9c4e77977e0cce7c...
see more 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...
see more 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...
see more
