Has anyone had an issue with old rows not being clearer out of a sheet generated by a Pivot? My only remedy so far is to delete all rows and re-run the pivot. Im thinking its a processing issue because it occurs with larger data sets.
If there's no data associated with those rows at all, then the rows should be removed from the destination sheet. Essentially the Pivot should re-create the entire table, only creating rows where there's data.
If this does not describe what you're experiencing, and you're finding that if the Rows selected no longer have one of the previous values yet it still appears in the final sheet, I would suggest reaching out to Support with a full recording of the issue (including both sheets and each tab of your Pivot workflow set-up).
With in Dynamic View's details panel is there a way you can start to type some of the drop down information to pull up that option instead of scrolling for the right one? See below 'Market' can't type. Am I doing something wrong or is this by design? If by design I vote for an update.
Hello, I am looking to leverage the Conditional Junction: Junction Match module to set a variable to ultimately decide which path to take. Taking a step back, I have 4 of the same 'When Column is Changed' triggers, which are attached to different smartsheets. Based on which smartsheet the trigger is associated with, I am…
Hello. I am a newer user of Smartsheet and am trying to identify an easy way for multiple contributors around our org to update data in a source sheet. Here is an outline of our scenario: We collect high level data of projects from around the Org in a "Combined Project List" sheet We would like to minimize access to this…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.