Cell linking
Discussion List
-
Can I give the RYGB Balls column "Status" a default colour when a new row is added to the sheet?In Archived 2016 PostsI 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…
-
Automating Harvey Balls based on RAG statusIn Archived 2015 PostsHi, 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 th…
-
two way linkIn Archived 2016 PostsIs there a way to create a two way link? By this I mean create a link that no matter which sheet I am on it will update both sheets. Right now I can create the link and I can only make changes on one sheet and the other sheet only sees tth…
-
Linking Sheets and SharingIn Archived 2016 PostsWe have a sheet being kept up by our quoting group listing such things as customer name, quote number, amount of quote, etc. This includes the sales person. We keep a similar sheet for orders that have been entered. We would like to ke…
-
Using a master list column and being able to link to other sheetsIn Archived 2015 PostsI have a question in regard to creating a dropdown list column. I want to be able to have a MASTER list that when I add a new item to the list that it will update to other sheets that contain the same list. Is this posible. I can see that …
-
Getting RowID in a sheet?In Archived 2016 PostsIs there a way to get the rowid for a different row for a comment. I have a schedule with a delay of 3d because of something external to the project. In the Predecesor column I have 23FS+3d because of the delay after completing the ta…
-
Setting date ranges with start-date to start-date and end-date to end-date dependenciesIn Archived 2016 PostsI have a project where I am setting a range of production dates and want the sheet to auto-update if I update that there is slippage in the timeline to see how far out things push. It is easy to schedule dependencies on the front end. …
-
Trying to build a report, is it possible?In Archived 2016 PostsI'm trying to build a report from our company sales pipeline. Our pipeline has 7 sales stages. I'd like a report showing the percentage of our sales teams success progressing prospects from stage 3 or 4 to stage 5 (closed). At this p…
-
Starting a task based off of a column selectionIn Archived 2015 PostsSorry if this is covered elsewhere and if it is can someone send me a link? Basically we are setting a sheet and are hoping to auto add a child row based off a column selection. Ideally we could choose what if any to prefill in it but ev…
-
Approval process automationIn Archived 2015 PostsI'd like to create a workflow which will collect data from a webform (can I edit the look & feel of the web form UI?) and have that data forwarded to several people for approval without the need to go to echosign. The webform is th…