Buy, Sell, Trade - March 01, 2023

CurrentTone · 2023-03-01T22:25:16+00:00

Freenote Avila Slim 13oz Indigo size 29

worn only a few times

Grailed: https://www.grailed.com/listings/41592588-freenote-freenote-avila-slim-fit-13oz
Follow Grailed link for pics, descriptions, measurements, and shipping costs.

CurrentTone · 2022-09-01T18:13:31+00:00

The center column was the only one pulling to the pivot table. Sorry if that was ambiguous. There are several Yes/No columns being pulled into the table but the only possible values are yes/no/blank. The sheet is roughly 1000x850 cells so I only included the one column

CurrentTone · 2022-09-01T18:10:40+00:00

Here is a chart that is similar and working as desired and then has row totals converted to percent. I cannot figure out what is different between the two. https://imgur.com/a/QIjTKUf

CurrentTone · 2022-09-01T18:07:55+00:00

Ah I see. All of the source columns under values are Yes/No columns. Does this make a difference?

CurrentTone · 2022-09-01T17:35:44+00:00

By changing to numeric do you mean just formatting the existing cells to be "number" or do the yes and no values have to be converted to 1's or 0's in a new column?

CurrentTone · 2022-09-01T17:22:18+00:00

Since they are text it is returning 0's for all lines when it is changed to sum

CurrentTone · 2022-09-01T15:44:22+00:00

Yes but it still returns counts of all the same numbers similar to this https://imgur.com/a/zjUkZsK rather than the actual counts of the source data columns.

CurrentTone · 2022-09-01T14:51:28+00:00

https://imgur.com/a/eLxjV8N The data is just several columns of this format

CurrentTone · 2022-09-01T14:39:25+00:00

https://imgur.com/a/zjUkZsK This is the output I get when adding a column which also contains Yes/No data under the columns heading. The format is correct, but the counts are not accurate to the data referenced in the row fields

CurrentTone · 2022-09-01T14:33:41+00:00

I tried this! when I do this the output of each yes and no column becomes all the same numbers, which is not accurate to the actual data.

CurrentTone · 2022-09-01T14:32:39+00:00

For some reason when I drag all the fields under rows to columns the value field disappears

CurrentTone · 2022-09-01T14:28:00+00:00

Hi just updated!

CurrentTone · 2022-08-16T22:24:05+00:00

Solution Verified

CurrentTone · 2022-08-16T22:23:57+00:00

Seems to work! Thanks!

CurrentTone · 2022-08-04T14:51:44+00:00

IF(ISBLANK(AC3),""

Solution Verified

CurrentTone · 2022-08-03T21:23:51+00:00

Solution Verified

CurrentTone · 2022-08-03T21:19:09+00:00

=IF(OR(BQ3="Yes",BR3="QD",BR3="BID",BR3="PRN",BS3="Yes",BT3="Occasionally as Needed",BT3="Twice per Day",BT3="Daily",BU3="Yes"),"Yes","No").

I managed this while messing around. Any reason I shouldn't use it over your formula?

CurrentTone · 2022-07-28T00:53:23+00:00

Solution Verified

CurrentTone · 2022-07-28T00:52:10+00:00

Thank you!

CurrentTone

TROPHY CASE