- 我可以从Durat脱钩完成日期ion in a Schedule
Hi, I need to delink the Duration column from the Finish date in a schedule. I'm creating a master / roll up schedule that is linking from multiple sheets, however I can't link the finish date as it's greyed out. It's dependent on the duration. Is this possible? Are there any work arounds?
- Percentage of Child Rows with Check Mark
Hi, I'm trying to get a Percentage of Child Rows with Check Mark. Can anyone help out? =COUNTIF(CHILDREN(), 1) + "" returns the count of checked boxes. =(COUNT(CHILDREN(), 0) + "" returns the count of total rows, check or unchecked. So I divided the two, but I get #INVALID OPERATION error. Any thoughts?
- Gantt View - Limit Columns Shown
Hi, I'm trying to limit the columns shown in Gantt View. We have some cells that are reporting info from a link. Sometimes these values are very lengthy. 300 words? The problems is this makes each row very tall in Gantt view, and makes the schedule difficult to read. Hiding these column doesn't help. Is there a way to…
- Sum of Children - not working
Hello All, I'm trying to get the sum of children. There are 4 children rows, with multiple rows beneath that. See image. In this case, the top row with cell value 0 would have a 2 because it's summing the purple 0 and purple 2. Purple 0 and Purple 2 are counting the cells below (children) that have checkboxes. I'm using…
- Feature Request - 360 deg photo
Please allow us to link a 360 deg photo into a cell. Currently the cell will flatten the 360 photo in the preview (in the cell) and in the pop up window. Can we get the ability to link in a 360 photo?
- Lock or pin from Editing and Deleting. Even by Admin
Hello, I'd like to pin or lock or freeze a column from being edited as that information is going to archiving and doesn't need to be edited for the next 10 years. But I don't want to delete it accidentally, or edit the column contents. It seems like the lock only prevents Editors from changing the content. How do I make it…
- Create Splash Page (printable) for each Line Item
Hello, I want the ability to create a printable page that pulls from each column data, with each row constituting a new page. Any ideas on how to achieve this? It's like the opposite of a Report. Cheers,
- Sum Children If other cells are Checked
Hello Community, I'm trying to get a sum of children cells if a checkbox in another column is checked. For instance, if Column A has row 1 checked, I want the Column 10 row 1 counted as part of the sum.
- print row in Form format
Hello Community, I'd like to print a row in the Form format. I can create a form from a Grid View. But I'd like to print the values to small 4x5 information sheets to be provided with archive boxes. I will have hundreds of entries, and I need to print them independently. Does anyone have any ideas?