-
Best "infrastructure" columns for portfolio reporting
I am wondering if someone has some advice on the best infrastructure columns to add to project sheets to enable formatting, portfolio rollups, metrics, etc. I current have automated checkbox hidden columns for parent, child, ancestors, milestones, status (based on due date). What other hidden columns do people include in…
-
Ranking Rows based on values in specific column
I would like to formulate a ranking system in a column that will base the rank on an existing column. Are there any functions that can do this?
-
Independent work days for tasks or resources?
I have holidays blocked out in my calendar, however there are certain tasks/resources where the holidays don't apply. For instance, China is closed for all of February for Chinese New Year and I have those dates blacked out, but I don't want them to apply for folks in USA who will still be working. Is there a way to either…
-
Sheet Column References in Equations
Is there a way to convert a column reference to a number like you can in excel? My problem is I'm to trying to input an equation that is a simple sum equation referenced to an input cell "x". Whatever number is put in for "x", will add to the column length that sum equation is good for, however when I try to do this, I get…
-
Automating check box for multiple values
Hi, I need help writing the formula to automatically check the box when any one of these three values is selected: Complete, Cancelled, or Passed_Conditionally. Thanks!
-
Checkbox checked, cancel RYG
Hello, I have created 3 columns for the RYG, if the project is in the early stages the color green will show, if it is due within 4 days, yellow will show, and when it is due in 2 days red will show. Now I have a checkbox for the employees to click if the work is complete and I want the RYG colors disappear when they click…
-
Form Submission Organization in Sheet
Is there a way to automatically move a new form submission to a nest under a particular row? For instance, I have 4 parent rows that nest several rows underneath and would like any form submissions to automatically be assigned under one of those 4 parent rows based on information that's submitted (if this, then nest under…
-
Submitting Product Enhancement Requests
I understand that by submitting a "Product Enhancement Request" it doesn't mean it will be actioned and even if it is, will materialize in the immediate future. I think that rather than it them seemingly disappear down a 'black hole' a published list and the status of requests would be useful.
-
one time change cell
Hi, There I would like to know if It is possible to freeze a column one's validation is given to make sure no more modification can be done. Thank you,
-
Usability of contact information
Does anyone know a way of using the contact information when a new contact name is up-loaded into the sheets? I specifically refer to the e-mail address, as i'm unable to copy and paste into an e-mail from that tab. To date i have just been using a separate column for e-mail addresses, but this seems to be doubling up on…