-
Adding up checkbox's
HI, everyone. Please assist here: How do I add the number of checked box's in a series of cells in a column. The answer is on the formula example sheet but I am not getting it. I have 7 questions that require a check to indicate yes or a non checked box to indicate no. I want to add the number of checked box's to get a…
-
Automatically clear a flag symbol when a completed checkbox is selected.
Hi, I have created a simple workflow for testing a product. Within the row is a flag symbol column which the user selects to denote a fault. And when the fault is fixed a check box is selected at the end of the row to say it’s been completed. The fault flags throughout the sheet are counted in a running total as is the…
-
TIME and DATE/TIME (long)
Hi, This is not a new thread, but rather a branch of the thread derailed (mostly be me) of this thread https://community.smartsheet.com/discussion/question-formula-results-reports starting here: https://community.smartsheet.com/discussion/question-formula-results-reports?page=1#comment-17893 The derailed topic is…
-
SUMIF with check mark
I have a column (Have we paid for this container?) and it contains checkmarks. I want to add up the total cost in another column (Cost) IF the checkmark is checked in the other column. This is what I have come up with, I get the #Unparseable error. Where am I going wrong? =SUMIF([Have we paid for this container?]1:[Have we…
-
BUG: Auto-fill behavior has changed
This used to work, I've used it in my workflow, documented it and passed it on to the customer. Now it doesn't. I have a sheet, 22 columns wide. At the top of the sheet are several rows (in this specific case 4) The first column has a formula in it in rows 3 and 4. Previous workflow: 1. User deletes all content from rows…
-
COUNTIF formula with a date
Hello, I am new to this, this is probably a simple formula I am trying to use but I can't seem to make it work. (I have read through the forums and tried all sorts of suggetions that I have found).. I have a column that has a date field, and some rows have dates entered, some do not. I need to reference on a sperate sheet…
-
Planing a load of production
Hello I'm trying to make sheet that I will be able to put orders, amount of planed hours on task and devide for different type of teams, employees. I have stuck on one logic function. At the moment, when not all informations are typed in, function below returns blank cell. =IF(ISERROR(PRORATE($[Total hours]32, $Start32,…
-
Automating RYG balls based on checkboxes
I'm trying to create a function to accomplsh the following: If coulumn 2 is checked, and column 3 is not checked, then the RYG ball in column 4 is green. If Column 2 is not checked, and column 3 is checked, then the RYG ball in column 4 is Red. When nothing in column 2 or 3 is checked, no RYG ball is displayed in column 4.…
-
JIRA Integration: converting JIRA estimates into Smartsheet duration
Hi Smartsheet Community, We've integrated JIRA into Smartsheet. Our goal is to use Smartsheet to view the high-level roadmap of a project, based on summing the estimates of all tickets in JIRA. In JIRA, our tickets are estimated in hours. When the workflow is synced via the "Original Time Estimate" field, they somehow…
-
Multiple Duration Columns
Hello. I'm a new Smartsheet user. I used the "built-in" duration column to calculate the number of workdays between the Planned Start Date and Planned End Date. I also need to calculate the number of workdays between Actual Start Date and Actual End Date. What is the correct formula? (It would be great if Duration were a…
