-
Checking Done for multiple cells
Hi! I am trying to find a formula to check a box Done when several other cells are checked done. Such as Master Task=done when Task 1, Task 2, Task 3 and Task 4 are checked done. My If Then formula doesn't seem to work. Any thoughts? =IF([Column2]1 = "Done", 1, 0)
-
Formulas_add random cells to a total
I'm trying to create a formula that adds together random cell totals together in a column.. what should the formula look like?
-
Formula Option (Similar to Google Sheets 'LOOKUP')
Hello everyone! And thank you for your time! I'm trying to find the solution for the formula.. In Google Sheets, I used =LOOKUP(B2,OrderDetails!B:B,OrderDetails!O:O) where B2 = was order number, OrderDetails!B:B = was the range with the same order number, OrderDetails!O:O = was current order status But in Smartsheet I…
-
Formula to update status on a parent row based on any child row
Hi, Wondering if it is possible to create a formula to change the status of a parent row when a child status is updated. We have a number of Parent Status's and Child Status's ie If All Children are Unallocated then Parent is Unallocated If All Children are Allocated then Parent is Allocated But if any Child is In Progress…
-
Help with IF formula
Hey Smartsheet Community, I am really not that great with making long formulas, especially with the "IF" formula. Could someone please help me with making a formula for the RYG balls where if the task is less than 50% complete turn red, if the task is between 50%-99% complete, turn yellow and if the task is 100% complete…
-
Apply Formula to Entire Column
I'm trying to automatically apply a formula to an entire column that concatenates info from cells in a given row into a document name, once data is entered into those cells. The only way I've been able to accomplish this so far is to just copy/ paste or drag the formula as data is entered in a new row, but I'd like it to…
-
Changes Report
Does anyone know if there is a way to produce a report or a list of rows whereby Column A has changed in the last n number of days? I'm trying to produce an exec level weekly report of key projects whose end dates that have changed in the last week.
-
Formula help sumif has no children
Hello, I want to sum up every number in a column only if the row has no children. I'm sure there's an easy way to do it, but I've bashed my head up against it and can't figure it out. Many thanks! Geordie
-
COUNTIFS formula with year
I'm trying to put together a COUNTIFS formula for my Sheet Summary that will count the number of items that are shown as Completed in the status column along with what year they were completed in. Looking at other discussions, I found this: =COUNTIFS([NVAP Phase/Status]:[NVAP Phase/Status], "Completed", [NVAP Completed…
-
populate a field based on if a due date is x days or less.
anybody by chance know what is the easiest way it possible to set up a formula that reads a field to auto populate a date that is say 10 days before another date (due date)