-
Updating multiple sheets at once - team management
I use different sheets to keep track of different types of information on each team member (HR info, work assignment, invoicing...). Because of the nature of the work, there is a high turnover in the team, so I need to constantly update rows (add, remove, change status). Is there a way to connect several sheets where the…
-
Automation notifications/requests to external/3rd party inquiry
I haven't ventured to using automation with external users/3rd party. Do these individuals need to be shared with the sheet in order to receive notifications/requests of any type? I know internally, individuals do not have to be. Also, I am assuming they don't need a Smartsheet account, either...?
-
Lock a column
Hi If I have a workflow that automatically populates the cell in a column, and I do not want that column edited by anyone else, can I lock that column? i.e. will the workflow work if the column is locked?
-
Sharing a sheet with a user with 2 different emails
I have shared a sheet with a list of people. They are all in my contacts. Now, they are transitioning to a new email. I added their new emails to my list of contacts but when I try to share the sheet with them, their contact with the new email does not appear at all. I tried changing the name in my contact list, so the…
-
Calendar View Issues
Hello, I am attempting to update the calendar view in project settings, so that a different date column is noted on the calendar, but it will not change. Additionally, is the calendar view able to show two date column dates? Thanks, Nathan
-
Automate daily export
Hi, Is there a way to automatically export a sheet daily? With COVID, I have created a sheet for everyone to check off if they are remote or onsite. Currently, each day the data is written over. I manually export the sheet at the end of the day.
-
Cell Linking
I am fairly new to Smartsheet. I hope cell linking is the correct term. I have created three Smartsheets. I want columns from two of the Smartsheets to auto populate the third Smartsheet. How do I accomplish this?
-
How to create a master schedule sheet in project prog schedule mode by linking other schedule sheets
Hello, first of all sorry for my English, I'm doing a translation from French. I work in the construction industry and we have big construction projects. Each major construction project includes several complex tasks. Each of these tasks is a project in itself and it has its own schedule. The goal is to bring together all…
-
Duration is incorrect and inconsistent within same sheet
What I'm trying to do: Link "start date" and "duration" from Sheet A to Sheet B What's happening: I can link the cells just fine. But the duration is being calculated differently/incorrectly. Eg I have one row with a start date of 10/4 and a duration of 5 days. Based on the sheet settings, the end date should be 10/8…
-
Drop-down values from another sheet
Is there a way I can refer the drop-down values for a field to the data on another sheet?