We recently migrated from a google doc to smartsheet for tracking a project portfolio. Google docs offered the ability to apply a Rank Order macro to let us sort the list based on a calcuated priority score for each project in the list. Here is an example of the macro: =rank(AQ3,AQ:AQ) Smartsheets lets us score projects…
Can this be done? How. Thank You.
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.
I would like to conditionally format date columns based on whether something is past due of not. Can I automate that in smartsheets?
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…
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…
I need somebody that has a good qorking knowledge of Smartsheet and can create a few event sheets for me. thanks.
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
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.
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…
