-
Are attachments completely deleted when a sheet is deleted?
Hi All, We are reviewing our destruction of confidential information process/policies. Wondering what happens to sheet attachments when a sheet is deleted? Are attached files / URL links completely destroyed and untraceable once the file is deleted from the deleted folder? Appreciate that any user downloads/reproductions…
-
Sheet not getting updated properly even if linked properly
hello my friends, I have a Master summary sheet that get updated via control center every time a new project is created. This master summary takes data from multiple sheets. For some reason, the data is not formatted properly, or it is empty or it is written Lorem Ipsum even if the data is rightly linked to the sheet…
-
Structures used to organize work
Hello, I'm interested in hearing ideas about any of the following: how you successfully use multiple sheets to organize phases of work across a project or program. For instance, has anyone had success tracking all phase 1-2 (for example: discovery and requirements gathering) tasks in one sheet and then, all phase 3 (build…
-
With a Dependency enabled, how to create Start dates for specific days of the week
I have a building project where tasks cannot begin until an item has arrived from a supplier, then the dependent task can only be carried out on specific days of the week, e.g. a wall cannot be painted until the paint arrives, and the task of painting can only be conducted on, say, Saturday and Sunday. So (in the example…
-
Trying to combine IF, OR, & AND
Hi all, As the title states, I am trying to create a helper column that is checked or unchecked based on a few conditions. I want to check the helper column box if statements 1 and 2 are both true or if statements 1 and 2 are both false. I had written: IF(OR(AND(statement 1@row = 1, statement 2@row = 1), AND(statement…
-
Apostrophes being added in front of numbers and column property changes to dropdown (data shuttle)
When I use Data Shuttle and I upload the source to the target, it is changing column property from text/number to a dropdown and adds an apostrophe before the number. I have 8 "discount" columns per sheet, but it only disturbs some of them. If I need to perform some calculations using those numbers, I can't. I'm not sure…
-
Combining rows with like names
We have a sheet set up with forms to allow for participants of a contest to #1 register for the contest, then #2 go to the second form to update their progress in the contest. Is there a way to combine rows when a someone submits the same name or email address, for easier tracking? Something that is automated to create…
-
Copy Row Automation
Hello! I have been tasked by my team's leadership to create a way that they can audit how often my colleagues are updating their project plans. We currently have a "Master Sheet" that lists all of our current projects and certain cells linked in from each project plan. The project manager is supposed to be updating their…
-
Combining/Summing Contacts from Multiple Cells in a Single Cell
Greetings, In a Contact Column, and in a ancestor/child relationship, I would like for parent rows to summarize/list all persons in the child tasks. Is Smartsheet able to perform this action? E.g. If the child records list: * John D * Claire H * Emily G I want the parent to show: * John D, Claire H, Emily G. I have tried…
-
How do I create an chart to show ongoing activity?
I use the following to surface data to illustrate submissions over time over a set period of time (set start and end date). This uses a metric sheet with the dates in one column and a function adjacent to 'look' for the same dates in my source sheet. How do I create it to capture ongoing submissions? IE no end date? How do…