-
address formula
What would be the formula to separate the address into plus for separation. I have tried a few different ways and haven't had sucsess.
-
Calculate with row numbers / Formulas not copied after adding new rows
Every now and then I notice that formulas are not copied when a new row is added to a sheet. Very often these formulas are placed in hidden columns and so it's not immediately obvious. So, I'm looking for a way to get an "alert" in a cell within Smartsheet whenever a cell in a specific range is empty, showing the amount of…
-
help - with formula/cell linking across multiple sheets automatically, without having to manually ad
Summary: I have loads of sheets in a "project" folder, 1 for each project, which have identical layout (column names etc). Each sheets has a region field, which is either UK, China, Japan, HK or Multi. I then have reports which take the relevant information I need from all sheets in the "report" folder, which is then…
-
[SOLVED]How to count the amount of children of a parent?
Greetings, and thank you in advance for helping a beginner at Smartsheet out. so thanks to the formel ="<PARENTNAME> [" + (COUNT(CHILDREN())) + "]" I managed to count the amount of children a parent has in the parent row. However now I would like to use that number(the amount of children) in a summary, but I just don't…
-
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
