-
How to enable users to view entire sheet, but only edit rows assigned to them
I want all the users in the dept to view the entire sheet, but only able to edit rows with their name in the "project owner" column. How can I do that? We use one sheet to list all projects in our dept. So we are adding and removing rows as new projects start and old ones end. We want all the dept personnel to be able to…
-
Transfer/Move/Copy Rows from one sheet to another, and keep formulas..?
I need to transfer rows from one sheet to another that contain formulas. I know that the simple copy and move options just transfer over the values of the cells, but I'm really hoping that someone has found a clever way around this. We've totally overhauled our use of SS and this little deficiency could be a show-stopper.…
-
Conditional Formatting for Kanban Card View
When looking at items in Card view, conditional formatting is an option but you can't apply the formats to the card view itself. Is there a way to change the color of card based on conditional formatting? Current apply to rules only work in the spreadsheet view.
-
Enhancement Request: Improvements for Contact List columns in Forms
When adding a Contact List column to a Form, if no contacts are listed in the column properties, the field shows up as a simple text entry. If contacts are added in the column properties, the entry changes to a drop down. However, the drop down acts as if the "Restrict values to list only" check box is checked, whether it…
-
EOMONTH formula request
I would really like to see the EOMONTH formula. There is a way to do that with the current formulas, but as an example of how long it is, here is what's needed for setting a due date to the end of the current month if there are more than 10 days left in the month or setting it to the following month if there are less than…
-
Could a task be assigned to a group of contacts?
I would be interested in sending reminders and notifications to a group of people. I don't see helpful including more columns to do so as the table will be too long.
-
Need help with #Divide By Zero error
I am trying to calculate the average duration taken to complete a project for a date range. I get a “ #Divide By Zero “ error and would like to use IERROR function to get 0 when divided by 0 instead of the error message. Please see the formula and the details below. =SUMIFS(Duration:Duration, [Project Complete…
-
Nested IF Statement for Flagging Duplicates
Hi, I am looking to create a nested IF statement that allows me to look at multiple columns for duplicates. It is only true if there is a duplicate in each of the columns. For Example: First Last Job Jeff Smith Programmer Jeff Smith Designer Jeff Smith Designer In this scenario, I want a flag checked off when ALL 3 appear…
-
Formula to automate Parent date
I can't seem to locate the formula that auto-fills a Parent date with the last date entered for a Child line item. It would be the same as the Start and End Date column parent cells, but those are system so I can't copy/paste the correct formula. EXAMPLE Parent Date | =last date entered below Child Date 1 | 1/3/17 Child…
-
Gannt Chart - multiple milestones on the same row
I want to set up a recurring set of weekly meetings over a 3 year project on a single row. So far the only way I see to do this is to have a separate row for each meeting....painful. I can do a roll-up, but it graphically shows as a continous bar. Preference would be a series of diamonds (milestones). Any ideas? Much…
