Sign in to join the conversation:
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.
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.
I just tried to create my first dashboard using the timeline chart widget. I have set it to open the source data when clicked however it does not work. I've done this multiple times without success. It seems this is not actually an option even though you can select it in the settings. Can someone verify this or is there…
Hello, I have two sheets. One is "Current tasks" and one is "Completed tasks". I have the rows (individual tasks) auto number when entered (2026-001, 2026-002, etc.). When the row is marked complete, it is moved to the "Completed task" sheet. The problem I am having is that when the row is moved the other tasks that remain…
Do you use the standard {Sheet Name - Column Name} ? Or do use a simple name that can be easily identified? Or Do you use abbreviations? Im curious and would like to know your approach, Im hoping I could learn a lot from your experience.
