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 June 2016
Discussion List
Sorting by "start date", sorting by "assigned to"
Does anyone have recommendations for how to sort a master sheet by "start date", so that the dates are in ascending in chronological order, and also how to sort by "assigned to".
Setting up a Point of sale Sheet
Good afternoon, I was thinking of setting up a POS/point of sale sheet on excel. I googled it and found instructions on how to do it. But the person that was nice enough to post the information wrote it assuming that everyone knows how to enter Macros etc.. Then it came to mind that I should check here. I did speak with…
Anyway to have parent automatically get checkmark?
I have a parent row with 5 children rows. Is it possible to set my sheet up to have the parent row automatically get the checkmark after all the children rows have been checked off? Example: Is there anyway to have Project A auto check since objectives 1-5 are completed?
Planned and Earned Value into Project
Wondering if anyone has done any formulas for either Planned Value (PV), Earned Value (EV), into their SS projects? I have all the costing,tasks, opex/capex.%Complete,dates.. in my projects and this would be my next step :)
Looking for a good Issues/Risk Log
Does anyone have a good Issues/Risk log templete?
Multiple Users on Master Sheet
We have multiple contributors to a master sheet. They are responsible for the rows that are moved to this master. Is there a way to allow them to continue to edit only the rows they have moved to the master and not be able to edit others rows that have also moved to the master?
Update Requests (Templates - multiple cc's?)
I have a standard request that gets sent to different people to update a row or rows. There may be more than one person responsible for the updating. I tried sending the request to 3 people but only the first gets the "open form" button. Also, I want to CC their supervisors instead of just me. Is there a way to create a…
Auto-fill formulas and corrupt references
Hello, I'm currently in the process of setting up a rather formula-heavy project sheet, linking project names, project numbers and multiple assignees to all the different tasks within the project. In order to circumvent the limitation of one assignee per task on my sheets, I've created additional (non-Contact list) columns…
Feature Request: Changing Rows in Scheduled Update Requests
It seems as if there's no way to change the rows to be updated in a recurring update request, currently. I think that this is very inconvenient and undermines the power of recurring requests: * I don't want to bother project managers with requesting status updates on already completed rows * I don't want to bother them…
Multiple Resources?
I think I found my answer, but I have a need to assign multiple resources to a single line (an event) within a sheet. We manage marketing tours associated with multiple drivers and multiple vehicles. In some cases, a single tour (or single event for that matter) might consist of 3-4 drivers and 3-4 trucks. When scheduling…
