-
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"?
-
Can I link a Smartsheet dashboard to a sharepoint page? Please read the task below:
I am trying to link a Smartsheet dashboard to a Sharepoint page but this Smartsheet is edited twice a year and specific people need access to modify and then the rest of the business needs access to just view. How do I do this?
-
Data Shuttle 'contains' filter does not return any results
I am trying to filter a column that has a list of document names. Some of the documents are 'plans' Example: Onsite First Installation Plan - v08 I want the filter to only return rows where the document name in the row has the word 'plan' in it. When I try the contains filter, Data Shuttle filters out all the rows and…
