Auto-Populate Hours Column

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)

Find more posts tagged with

Formulas

Accepted answers

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)

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.