-
Updating a sheet with two web forms
I understand that SS will not update the same row from two separate web forms. Does anyone have a workaround for this. I want to use a web form to collect safety issues from employees. i then want to send the information to the employee's supervisors to have them take some actions and report what they have done. I know I…
-
Auto linking cells once populated by a web form
Hi! I am trying to use a Web Form to populate a "Master List" full of 30 columns of information. I would like the info located on that "Master List" to trickle down into 3 different "Sub Sheets" that present only selected info from the "Master List". However I am having trouble getting blank cells to understand that once…
-
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…