-
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.
-
Formula Help please
Hi, I need a formula that will do the following please... In the field "How Many" they will select from a drop down list 1-200 201-400 401-600 >600 I will run the formula in the Cleaning Fee column. Depending on which one they select, I need values to go into the Cleaning Fee column So for 1-200 the value would be 150.00…
-
Prevent that modified date is set when value formula has been changed
Hi smartsheet, this would be very helpful: Make formulas configurable, if modified date is set, when resulting value is changed, or not. Background (as an example): We use a date formula called "relevance" with the result "today" for specific combinations of start dates, end dates and status. This "relevance date" is…
-
Webforms | Survey - Customizing Column Headers or Question Content
I currently use an external tool to conduct 200-300 surveys and collect data on project performance for my org annually. Data is exported from the tool and compiled in excel. I want to transition to SmartSheet to alleviate the manual survey creation and lift and shift of data. Problem: Each survey is customized listing a…
-
Nested IF's Based on Date and Additional Criteria
Hi All, I am trying to craft a formula that will help automate the pacing of tasks. I have four columns: Task Name (Text), Task Completed (Checkbox), Task Status (Green, Red, Yellow, Blue), and Task Due Date (Date). For Example. [Determine Target Audience] - [Checked] - [Green] - [1/24/2017] I am trying to automate "Task…
-
Regarding Formulas
Hi , I am new to smart sheets and i a bit confused about how theese formulas work I have bank register which the classfication by charge is used by coulmn set up as a drop sown list with categories i am trying to do the monthly Totals By classfication for example Auto expenses payroll etc, i am trying to find out which…