-
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.
-
Trying to create a fancy email with status reports from multiple teams
I'm trying to go a bit above and beyond, using SmartSheets to track the status of multiple projects across multiple teams. Currently, we have links to multiple sheets (one for each team) and they manually go in, add a new column per week, and fill it in with a bunch of text explaining the status of that project this week.…
-
How to reference 100's of items with corresponding triggers to designate an end date.
Hi - Our agency has a formal record retention policy that lists over 100 types of records that we store or have digitized in-house. Question to answer/example: If the documents for Site A fall under Record category 1, they should be destroyed on 1/1/11, which is 100 days following the trigger date. I was able to create the…
-
Dependency between multiple RYGG cells
Hi, Is it possible to create a complex dependency such that a task's status is derived from it's sub-tasks' status. i.e: Status Task AVG(ST1-4) ST1 R ST2 G ST3 G ST4 Y That way we could avoid manually updating task's status manually and also connect it between sheets. Thanks
