-
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…
-
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…