-
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…
-
Formula for a carriage return within a cell
Hello i have this formula for milestones, however I would like to format it so that the "Milestone Count, Milestone Reached, Milestones to Go are all lined up to the left of the cell. I cannot change the size of the cell as there are multiple tasks in that same column. ="Milestone Count. . . . . . . " + COUNT([Notify…
-
Average formula for cell values calculated from another formula
I'm using the SS Jira connector for Jira and have create a template for my team to use. As part of this template I want to calculate the % completed field based on the task's status (the built in % complete of the gantt project only work at the parent level after manually inputing a value for the child task). I've been…
-
Automatically update related tasks when one date changes
Hi! My team is using Smartsheet for project management, and I want to know how to update due dates for tasks that are related. For example, if my original due date is 1/1/17, and there are several other tasks that are related to the starting date (edit, layout, print, etc.), if I change the date of one of those tasks, how…
