-
Fetching Parent Cell value for Children Cells
Hello, I would like my Children Cells to fetch their value from the Parent cell. Is it possible? Will it be possible soon? NB - I do not want to fetch the value from the "cell reference" of the parent ("=[Related Invoice]1 ")
-
Cashflow Overview from Date columns
Hi all, i have checked almost every single discussions, but still looking for my solution: Case: building houses with 6 payment steps from our customers (revenue), and consider 6-8 payment steps for our contractors (cost) Note: this part we are able to do 1.) finally have a mastersheet with follow columns: January-December…
-
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…