-
duration adjusted for resource Allocation %
We would like to be able to keep track of absolute effort (in days), but the Duration column that effects End Date, should be adjusted for Allocation %. So if a resource is allocated 10% on a task estimated at 1 day, it would actually take 10 days (duration) of wall clock time. May be a formula where Duration = Effort…
-
Having problems with sums
Hello. I am trying to add some totals in a column. It's a pretty simple thing that I do in Excel all the time. I am just clicking on a few cells in a column to be part of a total. However, after a do about 3-4 cells, it stops working and the cell with the total says #UNEXPECTED OPERATOR. Any idea what I'm doing wrong?…
-
Is it possible to conditionally format a row based on the status of it's dependencies?
Hi, I'd like to colour a row, or perhaps set a column based on the status of that rows dependencies. Does anyone know if this is possible? Thanks in advance, Tom
-
Can you create Custom Functions in SS like you can in Excel with VBA programming language?
Can you create Custom Functions in SS like you can in Excel with VBA programming language?
-
Email Reminder When Task is 100% Complete
Is there a way to automatically send a email when a tasks completion column is changed to a 100 % complete?
-
Power Function from Excel
I converted a power function from excel "=0.8*(POWER((9600/1000),-0.5))" and once imported it comes up as an "unexpected opperator". Is there another work around?
-
Summarizing Data using CountIF
I have created a Status Tracking sheet with multiple records. Each record represents a summarized view into a detailed task template. Each record also has a Status field, which we use to describe the phase of the project that we are in (there are four phases). I have used Countif to count the number of records in a given…
-
Avoiding double entry in multiple sheets.
I currently use Smartsheet for one purpose and still use Excel spreadsheets for another purpose. I have however hit a problem and wonder if anyone can help and provide a solution. Currently I have a sales spreadsheet for each employee. Each sheet contains a range of data. The range is the same on every spreadsheet and it…
-
Count Dates
Hello, I have a date column. I need to be able to count the number of dates in the column. Is there any way to do that without having to create another column using checkboxes? It would be nice if Smartsheet supported the COUNTA function. Thanks!
-
Percent Complete inconsistent in population
My sheet is very odd looking right now. I've assigned % Complete to the % Complete collumn. My results however are not all presenting uniformly. Some are rolling up as %, some as 0.xxxx and I can't figure the reason. I understand they represent the same thing, but formatting matters for some of my stake holders.. It's…