-
Formula to collapse rows
I am looking for a formula to collapse the sub-task rows into the parent after all sub-tasks are completed. I found a formula that will check mark the parent row after all sub-tasks are checked complete, but want to collapse when that occurs. I would like to add that onto this formula: =IF(COUNT(CHILDREN()) =…
-
What is wrong with this formula in totaling in parent row?
I have a parent row I just can not get to toal the "Win Ratio" (it is a percent) if there is a ZERO in one of the child rows! It is driving me crazy! The colums are: Phone Calls | Accts Created | Win Ratio The Daily formula works even when there is a ZERO in it... I am using this: =IF(AND(ISNUMBER([Phone Calls]18),…
-
Date Formula in a Gantt Chart Cell
I have tried to add formulas in the start date column for a gantt chart that reference a base start date cell and add a certain number of days to the start date. Is that possible? Example of the formula I am implimenting: = StarteDate + 10 The gantt chart start and end date columns use the Date/Time type of cell and Date…
-
Help! sum children if word1 and if word 2 are in row
I am trying to sum children in a column if two specific words are present in a row(s). IF "word1" ANDIF "word2" are present = sum of children
-
Combine 2 or 3 cells into one?
I have a webform that collects data for a request, Department, Type, Etc. These are separate columns. I would like to somehow filter the some of the information received into one column, which would then be a code for that particular request. The code is then used in other locations as an identifier. Is there any way to do…
-
Check box without overwriting formula ?
Hi, Here's the problem I'm facing. For each task, I'd like the two following columns : - one checkbox - one harvey ball Users can either update the harvey ball or check the box. Can the box be checked : - Automatically when harvey ball = full" (=IF([Harbey Ball]= "Full", 1, 0) - AND manually by user, without overwriting…
-
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…
