So we have some re-occuring projects sheets that are used like check list. example: * Board Meeting* Put out Name Tags * Confirm Tech Times * Check AV Equipment And a lot of time they are all assigned…
I have been tasked with creating a time-tracking sheet to hopefully avoid looking elsewhere. We have various areas that work on the same project, so we need to track their work. I have started by crea…
Hi, I notice when you add a half day duration to a task, it places the half day at the end of the period, for example a start date of 13/11/17 (Monday) with a duration of 2.5 days will result in the h…
I am just getting started with Smartsheets. So far, I am really liking the ease of set up and functionality. One issue I am struggling with is how to set up intermittent dates for a single task. For e…
I run a smartsheet for tracking coach/client engagements. There are typically 6 or more sessions in an engagement. Neither coaches nor clients can have access to the sheet. I need the coaches to repor…
Hi, Hit a lil road block here. Trying to automate the symbols for my status column based on drop down lists, but i keep getting a circular reference when putting in this formula, =IF([Lead Result]1="W…
H E L P! What is a simple way to formulate the "Evaluation" Chart in the Screen Shots attached, based off ONLY the children rows of the 4 Departments on the top of the sheet in both the "status" and "…
Is there a way to automatically bring up rows that are in the bottom of the sheet? for ex: bunch of tasks that are live, done and on hold respectively. Is there a automated way to bring the live rows …
Hello, Is it supported to set a default format for parent/child rows? For example, when a row becomes a parent, automatically * set text to bold * set text size == 16 * set the row background color to…
I am trying to copy data from a source sheet to a destination sheet. The data on my source sheet is in columns, but I want it to be shown as rows on my destination sheet. I have tried to link several …