-
#INVALID VALUE error with collect/index/match/small function
Hi all, Feeling like I've got a real head scratcher here- I have been struggling with this formula creation for the past few days and am hoping that the gurus can help! Within my sheet, I have UniquePart pulling in a list of unique values from a source sheet. The frequency of the part within the source sheet is then…
-
Resource Management - Assignments and regional holidays - what am i missing?
I'm feeling very confused or very swindled. Either way not thrilled right now. I was sold on the promise that Resource Management will be SS's integrated (via add-on) resource planner, where you can apply different roles, placeholders, regional holidays, etc; and that this would all lead to improved task assignments and…
-
I need a formula to calculate projected hours based on start/finish dates
In a project plan we have start date, finish date, and an estimated hours column to track against budgets. I need to be able to identify and total projected hours needed by month. Formula should return and absolute 36 hours for December - populating 20 and 16 in Dec column, 28 hours for January - populating 8 and 20 hours…
-
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…
