-
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
-
Header column
Hi All, I am having the hardest time trying to figure out how to keep the top column of my sheet as a header column. Is there anyway to accomplish this in Smart sheets. I have created the form and a web form for users to add data but I want the data entries to post on the sheet under the header. I'm hoping someone can let…
-
Parent Rows as Milestones???
Is it possible to make a parent row a milestone as well?
-
Is it possible to apply conditional formatting to reports?
My current understanding of reports is that each row replicates the formatting from whatever sheet it pulls from. Is it possible to create conditional formatting rules within the report itself?