Sign in to join the conversation:
Is it going to cause any issues if I nest (indent a couple levels) data inside a sub-category, inside of a main category? (see attached img)
It shouldn't, but a lot of that depends on your formulas used (if any) and what would be further indented.
Paul,
I think Ezra is asking about if it works with Control Center.
Best,
Andrée
That would explain the SCC... Duh... Hahaha. Sorry about that.
Haha! No worries!
I recognized the structure and then the SSC but, I use it as short for Smartsheet Community
I have a to do list with parent tasks and children tasks. I have a status column with a dropdown menu with the options “Not started,” “In process,” and “Completed.” I want to have a formula that auto-populates the parent task with the status based on the children tasks. Here is the logic that I want the formula to use: If…
I have a parent row that I'm using to sum all child row values where Children = 0 and Status = "Not Started". This is my formula. =IF(OR(ISBLANK(Status@row ), Hierarchy@row = 0), "", IF(Hierarchy@row = 1, SUM(CHILDREN()), IF(AND(Children@row = 0, Status@row = "Not Started"), 1, 0))) However, if any of my task rows are…
Hi, I am trying to get a column that provides the Date (easy with Record a Date) but I need the TIME as well. Most of my tables I just use the right function on the Modified Date because the only thing updating those tables are automations or data imports. But a few tables have automations, data imports, and manual inputs.…
