-
Start-to-Finish Predecessors Doesn't Work as Expected with Multiple Predecessors
Hi there, I'm running into a roadblock I'm hoping someone could help with. I'm planning my schedule backwards from an end date, and using Start-to-Finish Predecessors as recommended in this article (http://help.smartsheet.com/customer/portal/articles/765727). Here's the problem: I have a task (let's call it Task 1) that…
-
Can multiple web-forms feed the same row upon submission?
Good Morning, I would like to have two webforms: one for an external user and the other for an internal user to each fill out and submit separately but have all the information from each webform compile and fill into the same row on the master sheet. Is there any way to link the two web-forms so they can feed the same row…
-
Getting the most recent item in a column
I am trying to create a project status entry form that keeps a running log of updates - and I want to take the most recent update and roll it up to a summary report. The data sheet looks like this: (attached) Line 1 is the summary line that will link to a master scorecard elsewhere. The value of [Report Month] on line 1 is…
-
Cell History Reuse
HI, I have recently discovered the cell history feature... I was wandering if it is possible to to retrieve the history and use it to replace the current cell info? Pretty much, would like to revert back to the previous data in the cell... Regards, Jordan
-
automated movement between parent grouping for roll up sheet?
Is it possible for a row to "automatically" relocate itself from (1) parent child grouping to the NEXT parent child grouping? Right now, I have to manually move them. I have a roll up sheet for our design clients. The roll up sheet is organized by stage of process and all information is auto filled in from the actual…
-
Predecessor numbers automatically updating
When I add new lines to the sheet, the predecessor numbers do not automatically update to the change in the number to the task to which it should be linked. How can I make sure they update as I edit the sheet?
-
Build report within a specific sheet?
Hi I've been setting up a standard highlight report (sheet) and have built links from my risk, issues and exception logs. Everything is working great so far but I want to automate some additional logic. I now want to bring in a list of 'deliverables' that have been completed during a specific period and then identify any…
-
Conditional Cell Linking
Hello, I could use some help on something I'm trying to do in SmartSheet. Scope of Project: I have a master inbound "Lead Tracker" sheet that I use to keep track of referrals sent in from various business partners. I would like for these business partners to have access to their own "Lead Tracker" as well which would…
-
Can I give the RYGB Balls column "Status" a default colour when a new row is added to the sheet?
I think my question speaks for itself. The RYGB balls type has 4 coloured balls. Which I'm using as follows. Blue = "New task" Green = "Active task" Red = "Finished task" Yellow = I'm not using this one. So what I want is for a new row in the sheet, is for this column to automatically turn "Blue" to indicate a new task. It…
-
Automating Harvey Balls based on RAG status
Hi, Could somoen please help with the formula I need to use to automate completion of Harvey Balls based on RAG status of four phases? I am using RAG status balls (Green, Yellow, Red and Blue) to indicate status of each phase of the implementation. I have four implementation phases and basically want the Harvey Balls to Go…
