-
Is there a webinar or video tutorial on how to set up the Project Management Office template?
I seem to get stuck whenever I try to add an additional project and the formulas between sheets don't seem to transfer properly. I've reviewed the written instructions several times but I can't figure out what I'm doing wrong. I would love to see an example of how to set up multiple sheets that roll up to the dashboard.…
-
How to count rows if box is checked in separate column?
I have a helper column to identify the columns that require data to be entered. I need help creating a formulat that will do the following: Count the total number of rows within a specific range of the "Entity Details" column, and have a box checked in the "Data to be Entered Column". (For example Rows 10-25, that have a…
-
Setting different working days for individuals
Is there a way to set different working days for individuals? I know that it is possible to define working days through the Project Settings function but I want to set this for one person only to reflect their part time working structure - is this possible? Any advice would be gratefully received. Thanks
-
IT PMO - RACI Matrix
Dear all, Does anyone have a template for a Project Management RACI matrix, like this one A Project Management Guide for Everything RACI | Smartsheet if not, I'm going to created. Do you know if there is an option in smartsheet like in excel to rotate the text diagonally? and to combine cell? many thanks in advance, Ana
-
Hyperlinks Not Exporting
We use our Smartsheets to track our production process. This includes having hyperlinks to the items on our Google Drive. Last week we were able to export this sheet and the links worked without any issues. Today, when we export to Excel, Google Sheets or PDF, where there once were links, there are now none. The links are…
-
Graphs from Excel into Smartsheet
Is there a way to take a graph that was created in Excel and import it into a Smartsheet? I can do it via a dashboard but I would like to have it directly on the sheet with the data.
-
Why can't Smartsheet work in an Ipad Browser?
I understand there is an IOS app but it does not come close to the computer browser based environment, it doesn't perform as well, doesn't have matching capability, heck even the user interface is different. I do not care for the app but I love Smartsheet in a computer browser. I am baffled as to why Smartsheet does not…
-
% Complete based on Todays date, Start and End dates
I'm looking to return a % complete based on the start and end dates and the current date. So if a task starts on the 17/7 and ends on the 31/7, and today is the 24/7 - the % complete would be 53%. - (I want to have this as a separate column so I can keep dependencies on the actual % complete column) =(MIN(TODAY(),*finish…
-
How can I set a dynamic filter on a report to auto change to today's date?
I have created a report to track upcoming go-lives to display on a dashboard, I currently have a filter that specifies an exact date, but is it possible to have a filter that pulls in data for a date 30 days before todays date or even today's date? For example, a condition that will say Original Go-Live is greater than…
