-
hierarchy numbering in sheet
Hi Team, Can someone help me how to get hierarchy numbering in sheet for example Project Plan 1.1.1 Resource of Project Plan 1.1.2 Conclusion of Project plan
-
I want to update a cell if any of the cells in a certain range of cells equals a certain text.
If ANY cells in Status3- Status7 = In Progress then I want Status2 to equal "In Progress, If ALL cells in Status3-Status7 = Complete then I want status2 to equal "Complete" @Paul Newcome @Andrée Starå
-
Calendar App - Details view of multi-select fields
Hello! On Calendar App, I'm having an issue with multi-select fields not showing up on the details view when multiple items are selected. However, when only 1 of the multi-select options is chosen, it does appear on the details view. See screenshots attached. Any ideas? My workaround for now is to include the multi-select…
-
Generating values that can be referenced in a drop-down
Hi, I'm looking to create a formula and cell reference system that can be used to generate a value that can be referenced in another cell or ideally a form. Here's the workflow breakdown. The field fills out a form that creates a new line with an auto-generated "Request Number" If the form has a "Build" in the "Request…
-
Normalized Rank Formula
Hello - I am trying to recreate the formula below in my sheet. However, instead of using tabs in excel (e.g. 'Project Type Weight'!B:B), I am tagging the row and dragging the number of rows down (row1:row100). I am getting either an unparseable or invalid operation error. Can someone please help? 🤣 Excel Formula:…
-
Entering dates as 'today', 'yesterday', 'tomorrow.'
I don't know who needs to know this but I found it interesting. If you're putting in a manual date on your table/gantt you can type 'today' to put today's date in. Without the alt+down to bring up the dropdown that I miss from MSP I found this super useful. You can also use tomorrow/yesterday (and possibly others) to do…
-
Tracking Employee Training and Certifications
Hello! We are trying to find the best way to track employee training and certifications categorized by department and type of position. Has anyone been working on anything similar that they could share? TiA!
-
Using a master sheet to change multiple sheets
Currently, I have a project template that I use for opening a new location. Our company is typically working on 5 or more location opening projects at a time. When changes need to be made to the basic structure of the project plan (i.e. deleting a task, adding a task, adding a column etc.) this change has to be made across…
-
Change symbol color based on specific criteria.
I want to change symbol color based on the below criteria. Red- if Status = "Scheduled" and Days open is equal to or greater than 14 Yellow- if Status = "Scheduled" and Days open is between 9 & 14 Green- if Status = "Scheduled" and Days open is less than 10 Gray-If Status = "Complete" I may not need the "status =…
-
Change Time into Military
Hi all - Looking for solution to a simple task. Using a form that shows date in this format: 8:00 AM, 9:30 AM, etc., Want to add a second column (that will be hidden from form) that changes this to military time. No calculations involved - only looking for the time conversion. Yes, we could ask for military time in our…
