-
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…
-
Is there an ETA to add the ability to Merge Cells?
I need to be able to merge cells and I read the posts that it is not availble but "votes will be put in" for it. Is there an update? I can't imagine it would be very difficult to add the functionality and it would make managing projects in SmartSheet much easier. Note: Changing the background color will not work as…
-
Consolidating names in a Columns
We use Smartsheet to manage several projects, with multiple and repeat customers. We need to create a report that reviews (2) columns (distributor and customer) from serveral sheets. We would like the end report to combine the (2) columns from all of the sheets and remove any duplicate names from each column. I have gotten…
-
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…
-
Can I link TO another sheet instead of linking FROM?
I need to link my issue log rows to a master issues log in a different workspace in SmartSheet. However, my boss does not want anybody to make changes in his worksheet unless those changes are done by linking our issue rows to it. The only thing I have been able to do is go into his master issue sheet and link to mine. Can…
-
Smartsheet and Asana
I'd like to be able to send things from smartsheet across to Asana and vice versa. Ideally I'd like to be able to send steps in Asana across to projects in Smartsheet. As Smartsheet integrates way better with google Calendar etc. Is this possible? What can you transfer between the apps? What can't you transfer? Thanks!
-
I would like to send my sheet to users for viewing purposes and only want them to have the ability t
I'm sharing my sheets w/ external vendors and want them to view all the data but only update their comments (1 specific column). 1) The update request does not allow the abiity to change some fields from edit to view only. 2) The update report is ok but does it send a request to the spreadsheet owner? So far i'm not…
-
Need the ability to filter reports based on project status
Here is what I need. I have about 50 projects within a workgroup that I am trying to manage. I have a report of tasks that are due within the next 5 days. Took some cluncky work to differentiate tasks vs summary tasks, but it was easy enough to do. Next issue / challenge. When a project stalls for some reason or another, I…
-
Macro like functionality
Is there any method planned that would enable a change to trigger other changes. For example, I'd like to be able to cut out a step in one of my sheets whereby if I mark a task as complete that it would automatically change the % complete column to 100 (and vice versa).
-
Automatic Staff Details
Hi All Is it possible to have detials auomatically filled in for a person. Eample i select person x from a drop down list to work on a course, the spreadhseet then gets the phone number and email adress of person x from a sperate spreadhseet and auto fills it. Thnaks in advacne for your help. Matt