-
Automating RYG balls based on completed dates in parent row OR children rows
Hi all, I have a sheet with parent rows where the status column is updated with a RYG ball based on the completion date and due date of the row: =IF(ISBLANK([Due Date]108), "", IF(ISDATE([Completed Date]108), "Green", IF(TODAY() - [Due Date]108 > 0, "Red", IF(TODAY() - [Due Date]108 > -7, "Yellow")))) The children belowβ¦
-
Counting children in specific column (resolved)
I have a sheet that I'm using to keep track of about 100 projects, eventually each will have several child rows. I'm not using sheet dependencies because I want my parent row to represent how many days are left on the project. To do this I have 6 rows: "Start", "End", "Duration", "Real Start", "Real End" , "Real Duration".β¦
-
Training Plans and Curricula
Does anyone have any templates that would show generic training plans?
-
"Web Page" Smartsheet Solution
I need to make available, to external companies, files that contain different types of design and manufacturing standards. We currently have an external, legacy website that hosts a smaller set of similar documents. This current system won't be scalable for handling the additional requirements. Is anyone out there usingβ¦
-
Recurring sheet with sub-tasks all nested.
"sub-tasks" nested under multiple main tasks in a recurring sheet; is there any way to open all the sub-tasks at one time rather than selecting each "+" to open them?
-
Moving tasks from a project to kanban
I am trying to find a way to move tasks from a project view to the kanban card view. I have not seen a way yet to do this. When i create a new task it adds to the project, but that is not optimal. Any suggestions? Thanks, Dan Melton
-
Uploading Contacts with a CSV file
I`m having issues uploading contacts. The only colum that will import is emails, however, I have first name, last name, email, phone in 4 colums. Has anyone else had this issue or is there something else i can try.
-
Track changes
Hi there, I am wondering if it is possible that when changes are made, for example after changing dates of tasks and phases, that when Smartsheet saves this, it would save leave the old file there for an audit trail. For example, I change the dates of five tasks, when I click save - I'd like this to be v2, and then eachβ¦
-
Smartsheet Google Docs Merge Add-on Enhancement Request
I didn't see this while searchign through the discussions. It would be very helpful to have a Suppress Blanks feature in the merge add-on so that if there is no data in the data field, then don't populate the merge template. As an example, let's say you are building a bulleted list in the merge document and you want thatβ¦
-
#Unparseable error
I'm using the system to monitor and report progress to our client. We do surveys on their sites and perform installations. On top of the sheet, I have locked 6 lines that I use for summaries of the totals with simple countifΒ statements. Any ideas on why?