-
Sharing Worksheet- Removing a person
I copied an worksheet to create a new worksheet that I am working on. Since this worksheet was copied the old owner is still a owner on my worksheet. I would like to remove the old owner from seeing my new worksheet. There is two owners on the worksheet. How do I remove the old owner from the worksheet.
-
today() function
I would like to conditionally format date columns based on whether something is past due of not. Can I automate that in smartsheets?
-
Contacts - name and company as ID
I am using Samrtsheet where I invite many participants to view or edit the sheets. Often I also have man y different users (contacts) that should be assigned to a task. The problem occurs when I have contacts with the same name e.g. John Johnson. It would be very beneficial to have a Company or another ID to deferenciate…
-
Need to Receive Out of Office Replies for Update Requests
I created a Smartsheet to collaborate with a department that is in another facility. The nature of our collaboration can be time-sensitive, and when someone is out of the office we need to know. The process that currently exists is to use email, so we get the automatic notification. However, when I tested this with a…
-
Help Wanted
I need somebody that has a good qorking knowledge of Smartsheet and can create a few event sheets for me. thanks.
-
Removing columns from multiple reports
Good morning, Upon occasion we discover that a particular column in a sheet and subsequent reports is no longer needed and should be deleted. Is there a simple way to do so, other than having to go through every report to see if that column exists within? Blessings, Loann
-
Autofilling Columns on different sheets
Is there any way to auto fill columns on different sheets. We run hundreds of events a year and it would be great if when we add an event the name of the event and other details are automatically added to our various staff members sheets without us having to send them all a memo of a new event to add.
-
Tip for Day to get the team to play.
One of the things that we have done as of late to speed the ability to work in the sheet and for people to move about in the sheet is hyperlink your sub sheets to your master sheet. The Hyperlink creates a fast way to go to anothe sheet without closing the main sheet. If you have you settings correct you can have a new tab…
-
Monitoring project activity
Has anyone got tips for quick ways to see who last updated a project and when it was last modified? I'd like to be able to quickly identify which projects have not been visited by their project lead for a given period of time so I can report this to exec sponsors. The home tab shows when a sheet was last updated, but not…
-
Suggestion for update requests
It would be really useful if the text, timing and recurrence of update requests could be amended after setting them up. This would allow the requests to be a more substantial and reliable tool for on-going communication with project leads. I quite often have relatively lengthy instructions/guidance attached to the requests…
