Does Pivot count values in a formula column? I've tried to write a pivot from a Report source where the column and values are the same formula column - it runs endlessly "Creating". Help Please
Hey @Gladys Liley,
The Pivot App does have the ability to count values within a Formula Column. This is still true even if the data is referenced within a Report source. I've created the example below on how this may be setup:
You also mentioned that you have set the same Formula Column to the Columns and Values Field. This is possible, but as the Values change, the Columns Field will change as well.
If you do find unexpected behavior, I recommend reaching out to our Smartsheet Technical Support Team here: Contact Support for further assistance.
I hope this helps!
Thank you, this worked!
Dear All: Good morning. We are VERY close to getting the approval from my top management for DataMesh - this is something I have been hoping to get for us since 2019. We were able to help 4 departments set up and become power users of Smartsheet last year. DataMesh will allow easier and faster inter-departmental data…
Can Document Builder be automated so that after a form is filled out the document is automatically created and sent to the person who filled out the form (or any other identified person)?
I have a DataShuttle workflow where users attach a spreadsheet to an intake sheet. Question1: If multiple spreadsheets are attached to the intake sheet (via a form) does the DataShuttle workflow queue up these attachment imports? Question2: If you have to attach a spreadsheet and wait until the workflow completes, how does…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.