Hello, When I send a row to someone in my contacts, I want the information that was been recently changed to be highlighted (to alert the person of the changed cells when the sheet is quite large). Is there a way to do this? I have the "Highlight Changes" on, but it does not show up in what is emailed. Thanks for any…
你好!我在寻找一个公式will show in the parent row an RYG color based on the children. If there are any Red OR Yellow in the children rows, I want the parent row to show Yellow. If there are only greens (no other color), I want the parent row to show Green. How do I do the "or" statement? Thanks for any…
We have a sheet that has a multiple level hierarchy. One of the columns is a checkbox and I used the formula ="" + COUNTIF(CHILDREN(), 1) to count the number of checkboxes below each parent row. This created the number of checked box in the parent row. Is there then a way to count all the numbers in the parent rows (to get…
