-
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…
-
Planko Status Column - is this possible?
Sheet 1: Col 1: Numbers in row sequence, i.e. 1111, 1112, 1113, 1114 Col 2: Status: Show / Unavailable Sheet 2: Col 1: Last Name Col 2: Number (index/matched from Sheet 1 based on Status Columns) Col 3: Status: Show Sheet 2 is a manual row entry sheet, and what I’m hoping to achieve is that when the status changes in Col 3…
-
Any ideas on how to make update requests look better??
Community; Any ideas or insight into how to make an update request look better? We are trying to use them as part of an (HR) performance review workflow. So, a staff person fills in a form with their info, a manager is sent an update request ... but the look and feel is not very nice. Open to ideas ... on any step in the…
-
Form Response Validation
How can I validate the format of responses? For example, I want phone numbers entered as 000.000.0000, so when a user enters their phone as 0000000000, or 000-000-0000, they will be shown an error message that directs them to enter it in the appropriate format. Also, is there any way to validate an email address?
-
VLOOKUP Doesn't Appear To Work With Auto-Number Columns/Cells
I have a main sheet containing a list of projects with the first column containing the ID of the project which is configured as an auto-number column. I am working on setting up another sheet to track projects tasks and want to be able to link a task to its associated project in the project sheet. There are select columns…
-
Trackers feeding other trackers?
Hello, What is the best way to "push" rows of data from multiple trackers into one tracker? Suppose user 1 and user 2 and a Manager use their own trackers. The trackers follow the same template. User 1 and user 2 must report progress from their trackers into their Manager's tracker. They must report entire rows from their…