Heather_Verde✭✭✭✭✭

There is not a way, yet. That's part of this ask.

This is a feature which would be extremely helpful

@Patrick_CFA I will put something together and get back to you.

Can you put an IF statement like =IF(Totals@row = "0", "0%", ([Metric 1]@row / Totals@row)) ?

I haven't tested it, but can you maybe have a helper column to identify if it's a parent and then in your column formula do the sum children operation if your identifying column shows it's a parent, and then another calculation if the helper column indicates the cell is for a child?

I feel like you need a helper column or some sort to identify the month end date (either by formula or a lookup value off another sheet). And then base you checkbox formula off the difference between billing date and month end date.

As others have said, it is difficult to narrow down. I try to see what impact anyone can have on my career. Whether it be a manager providing me with a groundbreaking opportunity, to someone I am training providing me with constructive feedback that helps me to adjust and better myself along the way. I would say the most…

我做类似的事情,林k pulled from a separate sheet where we house the event information. The event link is added to a column on the event data sheet. I then use formulas to pull over which event and the appropriate data to the registration sheet. When they register, they receive either a confirmation…

I think it would be helpful for formulas and maybe building out reports or dashboards. Like create a dashboard with information x, y, and z from sheets a and b and report c with a chart showing this and the report embedded. And viola!!!

@Alison Clancy it was awesome. We had front row tickets and scored getting a couple of guitar picks.