-
Pivot able
Hi Reaching to the Brain Trust We have a user who has been using Pivot Table - yesterday she suddenly started getting Error 500 and is unable to login and didn't share her pivots with anyone so the pivot tables are not updating and she cant access the ap Tech support are just going through the motions of check this and…
-
Dynamic View incorrectly blocks a users access
Hi, I have a Dynamic View set up that restricts the view by current user. The condition I've set up is for a contact column in the sheet called Review Access And in the sheet this column is populated with contacts: But despite this, one of my contacts, Jeff, in this column cannot access the Dynamic View. I added myself to…
-
Archiving Rule in Control Center Not Working As Expected
I have several completed projects located in an intake sheet that I would like to archive. I created an archive rule for projects with a status of "Ready to Archive" to move to a separate workspace. I also checked other freeze & disable features for items. When I tested one project, the only thing that worked correctly was…
-
Mapping Data Mesh Sums from a Report to a Sheet
Hello, I've done a bit of preliminary research but haven't seen a similar issue discussed. While I know Data Mesh can bring data from a report to a sheet, is it possible to use it to bring over sums from a report into a sheet? I have a report which includes line-level financial data and have grouped that data by cost…
-
Why is my workflow not updating my Smartsheet columns after initial run?
I have set up a workflow from an excel file to my smartsheet. I have it set that whenever a new sheet is added it should update my data, but that is not happening. Ex. One of the columns is for prices. If the new source attachment has new prices and i add to the workflow, the price does not change in the Target sheet when…
-
Who's Viewed Dynamic View
My company uses dynamic views frequently to share information with our field sales team. In one instance, if I view the activity log of the source sheet, I can see who has viewed the sheet using dynamic view. That information appears on the downloaded report as Action = Sheet Viewed and Source = API - Other Client.…
-
Attachments
Hi - I'm trying to create a data shuttle workflow for an excel file I've attached to my smartsheets file. my enterprise doesn't allow uploads from sharepoint or onedrive. is there a way i can have an excel file automatically upload bulk info to my smartsheets file?
-
Does the dynamic view work with formulas?
I have one of my sheets set up so the program chosen references another sheet and generates a contact. I have created a dynamic view to restrict the view so only the contacts of those programs can see and edit their data. Unfortunately, it's not working. Is this because a formula with cross sheet references generates the…
-
How to set the start of Q1 within the Calendar App?
We have a really nice timeline view of our work using the Calendar App and it would be really handy to be able to display the Week Number or even view by Quarter. However the interface doesn't seem to honor the the "Quarter Start Month" setting and always uses February. I expect Q1 to be from Jan 01 to Mar 31, not Feb 01…
-
Bridge - why Array Management Size/Length returning 1 even the array is empty
I am trying to check if the search sheet has any result or not. Even the result is coming as 0, the Array Management: Size/Length is giving output as 1. Anybody has any thoughts on this?