-
Revision to change tracking
I changed a column to "Locked" this morning and now all of that data shows up highlighted in the track changes view. I wouldn't consider this a change worthy of highlighting in everybody's reports. Can you please remove this type of change from the highlighting filter? The same goes for changing a column format - I changed…
-
Creating a report from a dropdown list value
I am trying to create a report that will pull in all rows that are under a certain value in a dropdown list. However, when going through the report builder, the dropdown list is blank (picture 1) although my actual dropdown list is populated (picture 2). Is this a known issue or am I doing something wrong? Thank you
-
Column Names - Tips and Tricks
1. Naming Columns: Changing a column name post-facto breaks reports and other stuff creating a lot of useless donkey work. Naming columns correctly at the get go is uber-important- think about it before comitting. 2. Make your formulas easier to read: Name columns with underscores between words, i.e "Due_Date" instead of…
-
Shared sheet not populating
I've shared a sheet with another user. For this user, only two columns have data the rest are blank. How can I fix this?
-
Is there a way to make my folder structure setup the default for everyone on our account?
Thinking of this like file explorer so that all of the sheets are organized rather than in one long list for the users I add / share sheets to throughout the team. thanks
-
Changing Duration to Hours changes my Finish time
Hi all, I am having a problem that needs your assistance. Most of our projects are done in hours over a number of days. I have changed the Duration to hours instead of days in my sheet but what it then does is change the Finish time. How have you corrected this? Your assistance would be greatly appreciated
-
Conversion Formulas / Cell Linking
I am cell-linking 2 sheets but 1 sheet records time in days and allocation: Example: 2 days and 50% Allocation = total of 8 hours spent on the project over the course of 2 days. (The duration can not be changed from days because this is our project management sheet and we use in the gantt chart to share with customers.)…
-
Roll-up distinct selections in dropdown to parent row
Is there a way to roll-up child dropdown selections to the parent row so that the selections show only once in the parent? Example: Dropdown contains: Red, Blue, Yellow Child 1 selects Red Child 2 selects Yellow Child 3 selects Red I found where I can use JOIN(Children()), but this will display Red, Yellow, Red in the…
-
No API access to Gantt Fields?
I see in the API documentation that the programatic access of row data in columns of type Predecessor, Duration, etc. is not supported. I'm doing what I've seen many others on this forum try to do; I'm merging several interdependent sheets into one "master" sheet. It need only be a snapshot of the others and needn't…
-
Blocking Exporting
Hi, Is there currently an option or setting to block a viewer from being able to export data? I cannot seem to find it. Thanks!
