-
Change Management Solution
Does anyone use Smartsheet for Change Management scheduling? We are in the process of creating a change management committee and are currently housing our Change requests in Lotus Notes Database.... Which is less than desirable. Trying to see how we could use Smartsheet to accomplish this... Anyone currently doing this or…
-
moving rows upon completion of task
We want to move completed tasks within a given hierarchy to the bottom of the list allowing active tasks to "move up" Ideas?
-
Reoccurring Event
Does anyone know how or is there a work around for entering a reoccurring event one time but have a reminder sent to you every two weeks vs enetering the event multiple times?
-
Tracking Assigned Tasks
Dears, How to view a specific person tasks on smartsheet, i assign multiple tasks for multiple users so what is the best way to keep informed or to check the update of a specific person tasks. Thanks.
-
Automate archiving of completed tasks
I've copied a sheet of "Current Tasks" so that I can use the copy to archive my "Completed Tasks," otherwise they just fill up my task sheet. I notice that there's a feature for linking cells, but I'm trying to figure out if it's possible to have the rows marked as "Completed" automatically copied to the "Completed Tasks"…
-
Status Order Tracking (similar to the Dominoes Pizza Tracker)
Was wondering if its possible to create an online sheet for my clients to be able to get Status updates? Ideally I would want them to go to an online sheet and put in their Invoice number and it will tell where their job is at (With Designer, Proof Sent, At the printer, Completed etc.) Does anyone know if this is possible?…
-
Ideas for Multi Department Service Request tool
All, We are currently using Smartsheet as a Help Desk Ticket system for one system, with two developers and two users that submit bug or enhancement requests. A webform is used to submit the request and email alerts and conditional formatting are used to track the status of the request and notify users when anything…
-
Set colors on cells based on value of another cell
Problem Statement: Based on New Hire Title, they are granted access to certain applications For example: If I select Manager from the title field, email, software, laptop cells will be highlighted as things that need to be done. Another example: If I select leasing from the title field, email, software cells will be…
-
Calculating Years Of Service
Hi Everyone, I currently am importing a sheet to manage in SmartSheets and one of my cell formulas is not functioning. Can someone please let me know if there is a work around to this. Currently in excel I have it as a =datedif formula. Smart Sheet currently shows the following error in the sheet #unparseable. Thank You
-
Filter based on color
Is there a way to filter a sheet based on the color of a cell in a particular column? So, for example, I set up conditional formatting such that when an item is overdue, a particular cell turns red. I would then like to filter the sheet such that only the items with that cell as red are shown.
