-
Indented rows not showing on PDF
When I print the sheet to pdf the indented rows are collapsed on the pdf but they are not on the screen view. This is not happening with other sheets. This paritcualr sheet has: - many links to other sheets - i am not an editor Is there something else I need to do for the indented rows to display?
-
Automatically Sum rows that have the same value in a specific column.
I would like to sum up the hours of a job according to what job number it has. This is going to be used as a Time Sheet. Therefore, mass amounts of entries are going to be sent to this report. I would like it to automatically sort the information and then sum up the hours of multiple cells that have the same job number in…
-
Merging the text of 2 cells into 1.
Hello, is there a way to merge the text of 2 different cells into 1 please? I have tried several versions of this but I get different error messages. =(([cell]1) &” “&([cell]2) Thankyou.
-
Sheet Size
I have sheets that vary in size but most lean to the larger size due to the amount of formulas in the sheet. I am looking to see if on average people are choosing to have more sheets and less size or less sheets and fill the sheets to the top. I have done alot of work to all of my sheets and some have had to be divided. If…
-
Automatically copying a row to another sheet depending on if a certain cell matches the sheet.
I was wondering if there was any way of automatically moving rows of information depending on information found in a specific column. For example. I have one sheet that lists tasks that have been done by employees and the job number that they were working on (i.e. 165-07). I also have other sheets that provide the…
-
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…