-
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…
-
Tip / Tricks - Simplify Date Management w "Days from Today" calculation.
Looking at long column of dates is cognitively challenging, but everyone understands a range of numbers, negative to zero and then positive. I originally used this scheme to simplify my conditional formatting setup but found that users really liked it so now I keep it visible. It also makes reports much easier to…
-
Automating swim lane changes in Card View
Does anyone know of a way to automate moving a card/task that has been set to 100% complete in the % completion data field into the "Complete" column / swim lane in the Card View (or for that matter, automating any swim lane change in the Card View based on any task data parameter)? Currently it's a manual process of…
