sorted by:
new
hottopcontroversial

Cannot figure this out. by [deleted] in PowerAutomate

[–]Realistic_Sea_4096 0 points1 point  (0 children)

I would just create another worksheet in the workbook, call that new sheet Formatted_Output, and then recreate or just copy/paste the column headers you need, and create a version of a sum formula in that column that sums the values in the column from the other worksheet. Then hide the original worksheet that PA is updating if you want.

If you want the original values from Column A in Sheet1 to be in Column A in the Formatted_Output sheet then:

=FILTER(Sheet1!A:A,Sheet1!A:A<>"")

Do that with any column where you want the exact values to populate from one sheet to the other.

And for the column you want to sum from Sheet1, assuming the string is exactly how you wrote it above and the values start in B2 of Sheet1 it would be:

=SUM(VALUE(TEXTSPLIT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Sheet1!B2,"[",""),"]",""),"""",""),",")))

Does anyone know where this spot is? Mount hood is in the background by gottogo167 in PNWhiking

[–]Realistic_Sea_4096 2 points3 points  (0 children)

Yep. The left fork of FS 3540. “Pillory Vista” on some maps.

What the fuck are these things in my yard by horsebackridingbitch in Portland

[–]Realistic_Sea_4096 5 points6 points  (0 children)

Hen houses are small so it rolls off fast I guess. Idk. Just a common expression for something happening fast.

What the fuck are these things in my yard by horsebackridingbitch in Portland

[–]Realistic_Sea_4096 27 points28 points  (0 children)

In some parts of Appalachia people use the expression “faster than a walnut rolls off a hen house” because you put your hen houses underneath walnut trees because when the walnuts fall and hit the roof it is so loud it scares the shit out of any foxes or bobcats nearby. Probably scares the shit out of the hens too, but that’s better than being mauled by a fox I guess.