-
Method to allow more than on option in a cell
Ok. Here is what I would like to do. I would like the ability for a user to enter their % complete in a cell and once that reaches 100% the check box will auto check. I would also like them to be able to click the completed box and have the % complete cell fill in with 100%. How I want to accomplish this is by using a…
-
IF(Is Parent Row....
I am using the below to calculate the "days since last contact" and it works nice. However, if the row is a parent I want to retrun blank, i.e. <> =IF(OR(TODAY() - [Last Contact Date]10 > 0, [Last Contact Date]10 = TODAY()), TODAY() - [Last Contact Date]10, "Never") The formula for check is a parent row is…
-
Changing the ball color on parent based on color of children
What I am trying to do is change the color of the RYG ball to red if any of the children have a red ball else leave it blank.
-
If checkbox is checked select this option from dropdown list
Does anyone know how to write this formula correctly? Basically, I've got a "completed" column that is a check box column. I've got a "priority" dropdown column with several different levels of priority includeing "none" so that I can sort my reports via priority. I would like the priority column to go "none" when I check…
-
Count of multiple values
Hi I'm workng on a risk log template and want to summarise the number of red risks (score 20), amber risks (score 15-19), number of yellow risks (score 10-14) and the number of gree risks (score <10). I thought I could use a COUNTIFS statement but I can only get it working to count all of just ONE value (example: 12).…
-
Getting RowID in a sheet?
Is there a way to get the rowid for a different row for a comment. I have a schedule with a delay of 3d because of something external to the project. In the Predecesor column I have 23FS+3d because of the delay after completing the task on row 23. I would like a comment ="This is delayed because of (reason) after…
-
Setting date ranges with start-date to start-date and end-date to end-date dependencies
I have a project where I am setting a range of production dates and want the sheet to auto-update if I update that there is slippage in the timeline to see how far out things push. It is easy to schedule dependencies on the front end. For example - if I have items: 1. PO to readiness of raw materials is 2 weeks from the PO…
-
New Smartsheet Improvements!
Check out our release notes page for all the details on the newest Smartsheet improvements, including email aliases, new formulas, API update and more!
-
SUMIFS Function with Multiple Column Sum Range
I want to sum values over a two column range using multiple criteria but when I include more than one column in the sum range I get a #MISSING OR INVALID PARAMETERS error message. When I back off the sum range to a single column it works fine. Is the sum range in the SUMIFS function restricted to a single column?
-
Auto assign helpdesk queries
Hi, I have set up a webform to collate helpdesk queries. Every query is one of 6 types (one of the fields on the webform is a drop down to select the type of query. I would like to automatically assign one of four people to handle each query based on which of the 6 types the query is regarding (there is a mapping of type…
