-
Formula on data from web form
I'm using a web form for a costume contest to be able to have people sign up. Due to the rules, they must be at least 18 years old to compete. I have a formula to display the person's age based off of the current date, but I want this to auto-populate when they submit from the form. Is there a way to do this?
-
Date Formulas Calculating Back From Deadline with Gantt Functionality
Hello Team Spreadsheet, Ultimately we'd like our company to enter a date that they would like to have their marketing materials and have smartsheet automatically calculate key dates prior to this date including the initial submission date which should be around 5 weeks prior to the end date. Here is our marketing team's…
-
Formula to count check boxes in row one of column
I have a questionnaire with multiple columns. Responses are either check boxes or comments. I want to summarise the total check boxes in each column. I can add a column and write a formula to total the checkboxes, but the error message "#1 or 0 expected" appears when the formula is in the same column as the check boxes.…
-
Smartsheet Formula Issues
I am trying to import a rolling completion log and I am having issues getting an aging formula to work. The formula looks at a date noted column and calculates total aging until a date is placed in a date resolved column. It also returns an empty cell if there is not a date in the date noted column. Any help would be…
-
Automating Harvey Balls based on RAG status
Hi, Could somoen please help with the formula I need to use to automate completion of Harvey Balls based on RAG status of four phases? I am using RAG status balls (Green, Yellow, Red and Blue) to indicate status of each phase of the implementation. I have four implementation phases and basically want the Harvey Balls to Go…
-
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).…