-
Automate RYG Balls based on % complete and start and end dates
I would like to have the RYG balls automatically adjust based on the percent complete and start and end date. For instance, if my task is set to start on 10/2/17 and end 10/13/17, if my % complete is less than 50% by midway between the two dates, to turn yellow. If my % complete is less than or equal to 90% by the end date…
-
COUNTIF based on a category
Hi I have a sheet which looks at another sheet and counts the number of instances of a string appear in that column based on a string in the current sheet and that works. I now want the sheet to look at the other sheet, carry out the COUNTIF, but also bring across the category entry from another column, so that i can use…
-
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…