Auto-Populate Hours Column

BonnieW

I would like for my Hours column to auto-populate with a "1" when I put a resource name in the "Assigned To" column. I have tried the basic formula but it is not returning anything when I add in a resource to the "assigned to" column

=IF(AND(ISBLANK([Assigned To]@row) = false, COUNT(CHILDREN()) > 0), Hours@row + 1, Hours@row)

Nic Larsen

At the basic level, you'd just need. This just looks at the cell and if it's not blank, it'll add a 1 to the cell this formula is in.

=IF(NOT(ISBLANK([Assigned To]@row)), 1)

Nic Larsen

At the basic level, you'd just need. This just looks at the cell and if it's not blank, it'll add a 1 to the cell this formula is in.

=IF(NOT(ISBLANK([Assigned To]@row)), 1)

BonnieW

What if I want to update the % after the fact with a different number? Right now, it won't let me. Is there logic I can add for that or do I have to manually remove the formula (which I don't want to do)

Nic Larsen

You'd be better off putting this result in a Helper column(s) to capture the updates and then using a SUMIFS or COUNTIFS formula to add it all up as you your checkpoints in your hours column. You can't both have a formula and manually add to it, but that's where having results hiding in Helpers can do that for you.