-
Gantt Sheet - Linking Dates
How can I generate the sub dates on a Gantt sheet using the duration? I would like to be able to copy my project and the subdates automatically generate from the head date? This could be generated by the duration. For example If the Head start date is 1/3/2016 I would like the sub dates to auto generate from the duration…
-
Can If-Then formula populate Primary column?
I need to populate the information in the primary column from a dropdown menu but cannot because of the type of column. If I place a column next to it with the dropdown information, can I use an If-Then formula such as =IF(ISTEXT([Client name drop down list]1), "Text", "Not Text") where I change the "Text" to equal…
-
Tracking Assets by location
I am not sure if this can be done in smart sheet. I need to track assets by location. There with be up to 50 assets by location and several thousand locations. I would also like t have the ability to add the bulk of the items from a location kit as all have common items with a few variables as to how many of each. All…
-
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…
