-
Report to show all Project Managers without duplicates
Trying to create a simple report that will list all project managers from (3) sheets without duplicates. I can get the report to give me all the project manager names without any issues. The problem I have is it showed duplicate rows of the same project manager. I would be ok with a single project manager name entry with…
-
alter working time
How do I restrict the working time to week days, I don't want the bars to go through the weekends
-
Enhancement Request: Show info for files attached from Dropbox (and likely others)
When a file is attached from Dropbox (and assume the others, haven't tested), the date it was attached is shown in the Attachments dialog. According to the API, this is the "CreatedAt" timestamp. What my customer would like is to show the modified timestamp from the file itself, as the documents won't be static instances,…
-
Managing Active Documents in Smartsheet
When it comes to editing a document that is stored in Smartsheet, I'm looking for the best way to manage active documents (e.g. word template that needs to be edited on a continual basis). It is a huge pain to have to save it somewhere else, edit it, then delete the old doc in Smartsheet and upload the edited one. Please…
-
Setting intermittent dates for a single task
I am just getting started with Smartsheets. So far, I am really liking the ease of set up and functionality. One issue I am struggling with is how to set up intermittent dates for a single task. For example, I have a single task where I want to set a date for every other Friday to meet with the client. I don't want to have…
-
Integrate with Microsoft Planner
Is there any possibility of Smartsheet integrating with Microsoft Planner? Smartsheet is equipment to manage full portfolio where Microsoft Planner seem to only focus on individual projects. I am a seasoned Project Manager and I need to see all projects at a high level view. Several departments within my organization uses…
-
Datamesh to Update Engagement Progress for Coaches and Clients
I run a smartsheet for tracking coach/client engagements. There are typically 6 or more sessions in an engagement. Neither coaches nor clients can have access to the sheet. I need the coaches to report the dates of each session in the engagements. Due to the nature of this environment, coaches can report any number of…
-
Does Smartsheet have an equivalent formula to Excel's TRIM to remove spaces in a cell?
Does Smartsheet have an equivalent formula to Excel's TRIM to remove spaces in a cell? Don't know if it's pilot error, a new feature request, or if there's a work around. Thanks! Eric
-
#Circular Reference when automating Yes,Hold,No decisions
Hi, Hit a lil road block here. Trying to automate the symbols for my status column based on drop down lists, but i keep getting a circular reference when putting in this formula, =IF([Lead Result]1="Win",Status1="Yes",IF([Lead Result]1,="Negotiating",Status1="Hold",Status1="No")) Posting a screenshot of my sheet for…
-
Smartsheet Experts
Hello I have been supporting a company in implementing Smartsheet. Successfully :) Today, I'm getting more and more involved in various other important projects and as a result need extra competent workforce to help me supporting our teams. Any interest? Raoul.