-
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…
-
Calculating Next Invoice Requisition Date
i Am Invocing our Clients every 2 weeks "Biweekly " I have A sheet set up like this Managers Name who Reprots progress Done Next i have a Coulmn called Date send Which is the Date we emailed The Invoice /Req To our customer Then i have Next Req Date Which should be calculated 2 weeks after the prior Send date Here is my…
-
Subtract 6 Months from Date in Another Cell
Smartsheet Community, I am trying to subtract 6 months from a date in another cell. What is wrong with my formula? The date from which I want to subtract 6 months is in row 203 in the "Date Completed" column. =DATE([DATE COMPLETED]203), MONTH([DATE COMPLETED]203)-6 Can someone please help? Thank you for your guidance.
