-
Parent Rows in Report
Hello, I have a made a current user report which shows only tasks where the current user needs to update. However I need the parent rows to show above the current user which may not be assigned to the same user. Is there any way to show parent rows in a report if there is filters that are applied which stop from parent…
-
extract city & state from a city, state, zip cell
I want to extract the city & state from a cell that has the city, state and zip code. The zip code may not always be 5 digits (either 90210 or 90210-1234) and the City and State may not always have a comma separating them. A formula that can extract any text left of a numeric value is what would solve this, but I cannot…
-
Information page
I would like to have a sheet with all of my part numbers and the various information that pertains to each part number on it. I would then like to have some sort of sheet or report that has a dropdown for me to select the part number I am looking for, then it will populate all of the information for that part but in the…
-
Possible to create a URL/Hyperlink for new item (Automatically)?
We would like to create a URL/Hyperlink for new item automatically...in the attached example I had to 1) Manually go to row, 2) Select Properties, 3) Copy the Row Link, 4) Paste the Row Link in the field. We would like this to happen automatically, so far everything I have read says it is not possible. Someone have a…
-
Merged: Form to Modify Existing Row
This discussion has been merged.
-
Schedule Health Balls Change Based on End Date and Status
I'm looking to have the schedule health balls change color based on the "Status" and "End Date" columns. Green = "Complete" OR "In Progress" with more than 2 days to "End Date" Yellow = "In Progress" with 0-2 days to "End Date" OR "On Hold" Red = Not "Complete" after the "End Date" Thank you!
-
How to track training hours across an organization
Hi, I need suggestions for how to track training hours for all employees. Each employee has a separate training sheet - it's broken out by training section with training items underneath. One of the columns on this sheet is Duration - this is used to track how many hours are needed for that training task. I need to create…
-
Formula does not appear to be working
Okay, first, here is my formula: =IF([Release Name]@row = "", "", IF(COUNT(ANCESTORS()) = 0, 1)) It is in the far right (second image) in the column named Is Parent, which is a checkbox. I only noticed this issue as a result of checking on these release numbers that are a variation of the same number with letters as a…
-
Duration and Predecessors: What to do when you have 1000s of rows?
Hi there, I have a sheet that contains original data as well as data imported from CSV files. We have a template that we use to copy the CSV data from different external sources. This template contains pre-built tasks and milestones, like this: The dates come in as TBD and the hierarchy is flat (no parent and child rows).…
-
Automatic Report for Multiple Ssheets
Olá comunidades, espero que estejam bem. I have a question about an action. I would like to generate a report for all my project spreadsheets. However, I need to manually insert the spreadsheets into the report, and due to the large number of projects, I would like to know if there is a way to do this automatically? Here…