-
Ability to automatically update end date on a row, after row is created based on create date
We are currently using a Form to submit requests for changes and would like to use logic to update the end date of a row after the form is submitted and based on the create date plus X number of days OR after a status is updated, if the end date is blank update the row based on X number of days. Is this type of function or…
-
Need a way to fix row id, so they do not move
Hi, Little background, I am using below formula to get the row id in RowID column =COUNTIFS($Name$1:Name@row, OR(@cell = "", @cell <> "")) Now whenever I sort my sheet on the basis of date, the row ids also changes because the absolute reference changes. I am fine with sorting but I want the Row ID to always start with 1…
-
Count all of the Level 1 Parent rows in a SmartSheet
In the document's Summary Sheet, I want to count all of the Level 1 parent tasks in the Sheet itself. In the example above, the answer is 2.
-
How can I get parent row roll up of child tasks health status
Hi - I am using health status which is determined by project status which is in turn determined by a planned vs actual task progress. I need the the health status to roll up to the parent row since I can't get an accurate weighted planned % complete in the parent row. I am using the following formula in child tasks health…
-
How to use Nested IF AND/OR Formulas?
I want to compare two columns Health and Date and populate the column for update required or not required. Conditions are If the date is in the past and Health is Blue - Update Not Required If the date is the past and Health is either Yellow, Green OR Red - Update required If the date is in the future and Health is either…
-
Searching for a value in a multiselect column
I probably should be going to bed, but I'm going nuts trying to figure out one last formula. I have a sheet with a multiselect column named "Project Type". The column has the following values: Revenue Opportunity Revenue Loss Avoidance Risk Compliance Cost Saving I am trying to create a formula along the lines of: IF…
-
Combining multiple views of a project plan in one
In our previous solution, we had five project plans for users to choose from. This caused reporting issues as our milestones did not align between project plans. Has anyone combined project plans into one template and allowed the user to see the appropriate tasks for their chosen project plan by perhaps a filter? Example,…
-
Count occurrences of each variable of a multi-dropdown list
Hi, I'm building a lease administration tool to help negotiate some leases. Each row (lease) has several stages (preliminary, negotiating, at lease, executed lease, open). I want to create a dashboard metric to show how many rows are at a particular stage: Preliminary - 5; Negotiating - 3; At Lease - 7, etc... What would I…
-
Date Range Conflict - Vacation Request Sheet
Hello, I've seen quite a few questions for date range overlap, but couldn't find the solution. The closest I found was the one below, but it was referencing another sheet, not the same sheet I believe, and not sure a simple edit to that formula will make it work for me. Form requests will populate new rows of all time off…
-
Saved Filters Issue Date Type Column
I'm running into a very odd issue with consistent filtering on a date column thats being generated from a formula: We have a column labeled "Filter date" that is set to Date (Restrict to dates only not checked) which has the following formula to trim off the date from a 2ndary column that is a drop down: =IF([Date…