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. Discussion List
Dependencies by Assigned User
Can dependencies by automatically set by Assigned User? i.e. Fred has 5 tasks each will will take a day - can the start and end date be automatically set with dependancies?
Send Update - To update only selected cell?
Is there any way to allow only selected cell for updates? Reason being that I would not want other data in the row to be accidently and wrongly updated. Thanks!
Gantt Chart - Is there a way to manually adjust a tasks start date without breaking dependencies ?
I'm creating a project schedule for the design and build of a new restaurant. The only concrete date that I know is the Tender date which is part way through the schedule. I filled out all the tasks and entered in the durations and predecessors for all the tasks. The problem is if I enter the date for Tender it only…
Web form submitted child rows - how to sort them into place?
Good afternoon, I have a sheet where we are tracking time allocated to various projects. Each web-form submitted project is then given a parent/child relationship with the child row being the submitted info and the parent being the summary view of all the children by the same project name. However, when I try to sort new…
Customize a Form
Hi, Does anyone know how to customize a form? Or are we stuck with the basic layout that shows up. We have several forms that clients fill out when they want to request a new report, report changes, Troubleshooting. I have created 3 smartsheets, 1 for each- and would like to have the forms match or be close to what they…
Can you schedule a report to run?
Hello, I just recently setup some sheets to help with payroll which tracks piece work (we're a manufacturing shop). They input the date they did the work and the number of pieces (I've built a sheet with every single part on it and put their respective price per part that calculates the total for that part). There is also…
Setup weekly Reminder till task is "Complete" - Reg.,
Hello All, I have a set of tasks which i requested my team to update once a week. In order to remind them, i want to setup reminders so that they receive email once a week. I saw someone telling to create report and setup reminders. But, i could not figure it out. Request for help here. Thanks & Regards Srinivas Poosarla
Conditional Formatting a section
I have a balanced scoresheet. I'd like to have the header "Business Development" Status circle turn from red to yellow to green as the tasks below it are completed. For each task, I set the measurement as "completed" and it turns the Status cell green. Once 1/3 of the status cells are green, I'd like to change the header…
If N/A checkbox is marked note % complete as 100%?
I have a "Not Applicable" and a "% Complete" column. I would like to create a formula that will automatically set the % complete to 100% if the Not Applicable checkbox is marked. Any suggestions? Thank you!
Trying to build a good, dynamic task list
I'm working on getting a good personal task list system going within Smartsheet. I've gone through a small number of efforts to get what I need, but I still have a problem around getting something dynamic and quick functioning. 1. Built a task list based on the task list template. With no automatic sorting, I have to sort…