-
Can dynamic views be created from sheet summary reports?
I can see the summary reports in the source picker when creating a dynamic view, however when I select the report and click the Create button, the process hangs. I've had the same results a summary report with multiple source sheets and a summary report with one source sheet. In both cases, the Create button turned from…
-
Is there a way to automate sheets using Dropbox?
I was wondering if there is a way to transfer information from Dropbox into Smartsheet. I've read some articles about Data Shuffle and Bridge, but I am unsure if those systems can do what I need. What I am looking to do, is when a certain file or folder is updated in Dropbox, or new information enters a file, I would like…
-
Data Shuttle expressions
Hello How can I get the total count for all entries on a weekly basis using Data Shuttle? Currently I get the total count imported to a sheet. This count is currently 26 entries and it fluctuates weekly. I would like a way that data shuttle using expressions can provide me this total count in one cell. Thanks for your help.
-
How can I upload Excel without losing groups and hierarchies?
My excel has rows that are indented to show groups and hierarchies. Can Data Shuttle do the upload so that I don't have to manually recreate ancestor levels?
-
Flow charting process
I work for a non-profit and I have been tasked to flow chart all the process and procedures and to create swim lanes. How can that be easy done in smartsheet? Thank you, Nigel Lomax
-
Smartsheet Pivot App & Calendar Apps
Hello, I am looking to build a pivot table, but I see an App is required in order for me to do so. Does anyone know whether you need to continue subscribing to the monthly app after you've built the pivot table in order to keep viewing it? Additionally, how helpful is the Calendar App versus building your own annual…
-
Is there a way of conditional formatting cells with dates with a hyperlink attached.
I have conditional formatted all cells to fill green when the date is in the past 730 days (2 years), and to fill red when the date is before 2 years ago. Those are the only two formats I have for every cell. Now I want to add a hyperlink to each cell. I use the CTRL+K function, type the URL and display the same text as…
-
Pull Report from a Control Center Project that includes the row on the Intake Sheet
Hi there community, I'm hoping there's a guru out there who can help me! I'm trying to create a report that includes different sheets from a project that was provisioned with control center. HOWEVER, I want it to include the row from my intake sheet that the project was provisioned from. The report that I'm trying to…
-
Syncing task to Outlook Calendar
Hi, when I sync my task list with Outlook Calendar, it shows in Outlook as a 'tentative' event that needs to be 'accepted' or 'declined'. I am wondering if there's a setting to change it, so it will add it directly to the calendar rather than showing it as a tentative entry. I looked in settings but couldn't find that…
-
Bridge - Filter an Array Object by a Particular Field
I have an array of objects that I need to filter and find a particular field in Bridge. ex. [{name: 1, id: 123}, {name: 2, id: 321}] In this case, how would I select the id for the "name" key/field whose value is "1"?