-
One Dependency for the start, another for the end?
Hi... I'm trying to set up a project that has a task (weekly update reports) that begins with one dependency (e.g., start of project), and ends with another dependency (e.g., on-site work). There are still some administrative tasks that continue after the on-site work is done, but I won't have to continue the update…
-
Help with the Alt-Enter function
I have not been able to find the answer to this question in the forum. I have tried using the Alt-Enter to enter data on multiple lines in a cell. However, when I leave the cell, the data reverts to all being on the same line. It is not displayed on separate lines as I want it to be. What am I missing or doing wrong to…
-
Sorting
Hi all- My question is about sorting. I use reports all the time. All.The.Time. And I'm encountering a particular issue that I don't understand that I never really noticed before. If you sort a report, then change the report to sort a different way, I thought it would sort again with the way it was sorted before as the…
-
why when I remove a person at a sheet level is their permissions removed from the workspace level?
My co-worker are both admins at the workspace level (which allows access to all of the workspace). How can I remove my co-worker just at the sheet level to avoid aerts to every one shared to the sheet ? When I removed my co-worker at the sheet sharing level they were removed from the entire workspace.
-
How to include links in automation-sent email?
I have an automation set that sends a row of info when triggered. In the Attachment column is a link to a Google doc. But when the email is sent, there is no link shared. Our security team will not allow attachments of actual documents so we have to use links. Am I missing something, or can I do something different to…
-
Automated Copy Row Function
Good afternoon We have a master sheet that we need to create additional sheets from based on values in a column. We will be using the automated copy row function. How do we make sure that when one row is changed in either sheet that it changes the other sheet....so if the master sheet changes so does the added sheet and…
-
Can I change tasks visibility in a shared smartsheet?
Hi, I am trying to find out the best way to work with smartsheet in a particular scenario. I have project smartsheets that outline project milestones, and tasks within. This sheet is shared externally to my team for collaboration. In many cases, some of the tasks might drive subtasks, or small actions that the internal…
-
Running Total in Pivot Table Smartsheet
Hey! I have a form linked to a sheet, and everytime someone replies to the form they are "raising a question". We have people working to solve these questions, and once this is done they change the status of this question to "answered" by checking a box in the sheet. I have the following columns: (1) Form submission date…
-
How do I create an automatic updated sheet, that pushes information from other 2 smartsheets?
Team, I know you can do it. I have two databases (same structure, different information), but I need a third that consolidates the two previous. If anything gets added in the sources, it needs to be automatically added in the third. If anything gets UPDATED in the sources, the third needs to get updated.
-
grouping columns
I'm new with Smartsheet. I want to replace some of my work scope I'm doing currently with Excell by Smartsheet. For this I have two question: 1) Is it possible to group columns as you can in excel? 2) Is it possible to merge cells (horizontally)? Regards Chris Grouping in excel Merging in excel