-
How to write a formula to sum up child values into Parent row?
How can I write a formula that sums up all the effort (hrs) into the parent row for which those tasks are under?
-
Formula that updates a cell in another column
Does anyone knowif there is a way to have a formula in one cell update a cell in another column? Currently I have a formula for a check box column (Task Complete Column) that checks the % Complete and if the task is 100% complete the check box is checked automatically. eg: (=if ([% Complete]4,1,1,0) This updates the check…
-
Formulas and data
I have a fairly simple sheet used to track travel costs by subcategory and estimate/actual comparisons. I want to add new data lines into the sheet inside the subcategories and have the subcategory total formulas automatically adjust to the larger data table. When I try it the formula data range remains static, referencing…
-
how to count rows under a parent and sub parent(s)
I have a sheet that is grouped by product categories. Underneath that category are products, and within/under a product are projects that are active and/or planned. So imagine the structure of the sheet is: Product category Product A Project A Project B Project C Product B Project A Project B I would like to display a…
-
Command + L on Mac - Is it working?
I am working on formalas in Smartsheet using a Mac. From my understanding, clicking Command + L is supposed to convert a relative reference to an absolute reference by automatically inserting the "$" in front of the column and row of a formula, but it does nothing. However, if I go to my browser and click Command + L all…
-
Counting Characters for Twitter
Hello! I'm using a sheet to track my social media (Twitter only at this point) posts prior to adding them to Hootsuite. I'm trying to figure out a way to have a column that will incidate wheather or not a text column has too many characters (140) or not. Is this possible?? Thanks, Claire
-
Help with Status and Date Columns
Hello, I am having trouble with a formula. I have 3 date columns, and 1 status column. I would like the status to change with the input of a date in the columns. Here is the reasoning for the question. I have "Ready Date", A "Start Date", and a "Complete Date". When a date is in the "Ready Date" column, I want the status…
-
Count number of cells containing specific text
Hi, I need to count the number of cells that contains a part of a text. Is there any wildcart symbol I could use? for example abcd abfd abpd jged In this case I need a formule that count the cells with the text starting with the letters ab. /Michelangelo
-
Can the SumIF check against multiple values instead of one?
I need to sum up a column if the value of another column is equal to EITHER X or Y. I was able to write the formula to check against 1 value but I want it check against mutliple values. =SUMIF([Hours]1:[Hours]10, Org104:Org110, "X") I want it to become : =SUMIF([Hours]1:[Hours]10, Org104:Org110, "{X", "Y"}) Is this…
-
Tracking resources, their hours per task and their hourly rate
Using a standard project template, is there a way to track resources (licensed and non-licensed), their hours per task and their hourly rate. This way I can calculate their total hours worked x rate to get their cost.
