Excluding Parent Row From Auto Populating System Data
Sinema
✭✭
Greetings,
I'm trying to exclude my parent rows from auto populating my Status and all my Modified By and Created By data.
Is this possible?
I tried adding - into the fields that I could, and nothing happened.
Comments
-
Modified and Created type columns are not able to be edited or overwritten. Either they are there for EVERY row or no rows.
One workaround though would be to create another Helper column of the date type and use the formula
=IF(COUNT(CHILDREN()) = 0, Modified@row)
or
=IF(COUNT(CHILDREN()) = 0, Created@row)
to pull the date from the original column if the row has no child rows (meaning it is not a parent row).
This will only pull the date though.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives