- 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.
的一件事,我们有堂e 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…
- Microsoft Project Import
Hi All, I use smartsheets mostly as a project management system for my clientbase. Most of my clients reuiqre porject schedules to be in Microsoft porject and I prefer doing my plans in MSP as it has much more funcatonality in terms of cost tracking, rsource planning etc. I import project plans from MSP into smartsheet and…
- Alert for RYG's
One person is wanting to be notified when their RYG ball turns green, which means a document they are needing is complete. In the notifications, I can only choose for her to be notified when that column changes for anyone. Is there a formula I can do that will accomplish this? Blessings, Loann
