-
Workaround for resource leveling or displaying resource constraints w/o resources enabled
Working in small company, so we dont' have ability to purchase 10000 or have every resource assigned projects be SS users...is there any sort of workaround that could present similar picture?
-
Keeping Reference Sheet Formula
Hello, In Smartsheet, I have a metrics file that has formulas to consolidate numbers (sumifs) by referencing a raw data file. The first version of the raw data file was imported from an Excel file, and it has data in thousands of rows. Every 2 weeks, the Excel raw data file will be generated by our system and I will get an…
-
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…