-
Formula Confusion!
We are trialling smartsheet and overall enjoying it so far however we have run into a bit of brick wall and any help would be appreciated! We have a main sheet with all our orders on it, using an older version to muck about with layout at set up at this stage hence the old haulage dates! Each order has details of the sizes…
-
Recording the date of a specific update and locking that date?
Greetings SMARTsheeters... Not sure if what I'd like to do is possible in SMARTsheet, but here goes... I'm working on a SMARTsheet that receives data adds and modifications from SMARTforms and autoupdate email requests. There will be various users entering and modifying the data in the SMARTsheet adhoc through these forms…
-
Actual % Complete Formula?
I'm trying to answer some questions on why the Project % Complete values are what they are, in greater detail than what is provided in this help article (which just indicates that it is calculated by Smartsheet based on Duration and % complete of child rows). Does anyone know what the actual formula/process is that…
-
help with average formula
Hi, I am having trouble with getting an average of a column. its a formula based column and since some rows dont meet all the criteria, some rows state INDEX DATA. How do I find the average of the numbers in the column using a formula?
-
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…