counting works perfectly in the rows above - is there a way to repair the sheet and the formula?
When you remove the hierarchy, they are no longer considered Child Rows vs Parent Rows which means that the hierarchy based functions such as CHILDREN will no longer work as intended. You would need to either specify your range
[Column Name]12:[Column Name]32
Or use a helper column to designate not only which rows should be considered a child row but also which row they are a child of. Then you would need to adjust your formulas to evaluate this new column in place of the CHILDREN function.
You don't have any children rows indented underneath of "Neue Vorgange".
thank you for teaching me a new word = indent ;-) - I had to look it up ;-))
No, all child rows are in the same position as the "mother row" - as shown in the screenshot above.
But I had to delete child rows several times because if I ad a new row by filling out the Smartsheet form
there is always a gap between the old and the new row (about 8-10 rows in between)
strange - isn´t it ?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Hey Smart Heads, I have another question about our beloved topic of formulas. Background: I have a autogerated column with row created date. In the file, rows are added in 2 ways: In bulk, by senior auditor Ad-hock by auditor I would like to diferentiate these two types of inflow. I came up with an idea of finding…
We had an employee leave and we are unable to edit the fields directly in the smart sheet. They had some kind of system set up where their fields were being populated via a dynamic view. I can not longer access this view because the person in question left our org. Is there a way to get access to that view now their…
What I intended to do is super simple: bring two sheets into one Row Report and do a simple pie chart on the status field. -> Source Data: two sample sheets A&B have exactly same fields. and the status is a dropdown list with single value -> The roll up row report, only picked the status field from the two source sheets.…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.