Sign in to join the conversation:
Hi,
I'm not able to get the sum children to calculate on the parent column and still showing a zero amount. Any suggestions?
It looks like the numbers are formatted as text. Can you check?
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Are the green rows indented under the Total row? They are not considered children unless they are indented.
You might also need to ensure that dependencies are enabled.
Andree, I believe they are formatted as numbers since they are left justified (unless they were manually changed to be that way).
I would have to start with Dan's suggestion of making sure the rows are actually indented.
I think the issue is in the numbers formatting. It's probably the multiple commas/punctuations that are throwing it of.
What's the formula in the parent?
Can you describe your process in more detail and maybe share the sheet(s) or some more screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic weekend!
Andrée
Paul,
I think you're right and I think it's the formatting of the numbers that don't work.
Andree, I have quite a few sheets that have punctuation in the numbers, and they calculate just fine. The only way I can get the commas to display is by using the comma button in the tool bar. If I manually enter a comma while typing in a number, it is displayed without it.
It's different depending on the region, so it's probably not the same. Can you have commas and punctuations at the same time in your number cells?
The only punctuation I can use in a number cell are commas and decimals. Anything else or multiple decimals will register as text.
If I manually type "1,000.00" and then hit Enter, it will display "1000".
I have to use the buttons on the toolbar in the screenshot I posted above to have the comma(s) and decimal displayed. Even then it still works as numbers when used in formulas/calculations and stays right justified.
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
Currently Triggering recurring workflows are only supported at the top of each hour. For instance 10:00, or 11:00, etc. Would like the ability to set 10:30 or 10:45. Perhaps the inteface can stay hourly so it doesnt get huge, but have the ability to manually edit the time directly to any custom time.
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…
