Cell linking
Discussion List
-
Can multiple web-forms feed the same row upon submission?In Archived 2016 PostsGood 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 t…
-
Getting the most recent item in a columnIn Archived 2016 PostsI 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…
-
Cell History ReuseIn Archived 2016 PostsHI, 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…
-
automated movement between parent grouping for roll up sheet?In Archived 2016 PostsIs 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…
-
Predecessor numbers automatically updatingIn Archived 2016 PostsWhen 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?In Archived 2016 PostsHi 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 lis…
-
Conditional Cell LinkingIn Archived 2016 PostsHello, 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 …
-
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…