change cell value in a date Column via automation

Hi Community,

following szenario:

I have a helper checkbox column "Has CHildren" indicating, if a parent row (Generation 1) has any children rows (Not all rows will have sub rows)

If so, I want to change the value in the column "Due Date" via automation to

=MIN(CHILDREN() to automatically show the next due date of a sub task.

I need this to be able to sort by this column.

Unfortunately, the action "Change cell value" does not support date columns.

Does anyone have an idea how I could make this work? Looking forward to your genious responses!

Philippa

Find more posts tagged with

Accepted answers

Paul Newcome

You can't output formulas using a Change Cell Value automation. If you do not want to do this manually, you will need to leverage the API, the premium add-on Bridge, or some other similar third party app.

All comments

Ok thank you Paul!

Happy to help. 👍️

Paul, is there some way to do this using a formula? I feel like there should be a way to have something like:

=IF(COUNT(CHILDREN([Primary Column]@row ))>0, MIN(CHILDREN([Due Date]@row), [Due Date]@row)

in a helper column, but the above keeps returning 0 for me, not a date.

Paul Newcome

@jjg279 It looks like you may be missing a parenthesis.

=IF(COUNT(CHILDREN([Primary Column]@row)) > 0, MIN(CHILDREN([Due Date]@row)), [Due Date]@row)

jjg279

That's got it! Sort of… when Due Date is a "Date" column type I get #Invalid Column Value. If it is numerical it works though.

Paul Newcome

@jjg279 Make sure the Due Date column as well as the column you are putting the formula in are both set as date type columns.

jjg279

Ah-ha! Ta-da! Thank you, that's got it. I appreciate the help!

Paul Newcome

Happy to help. 👍️

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.