-
How to only view my own tasks on Google Calendar
I would like to be able to set up the Google Calendar integration so that it only shows tasks assigned to me on my calendar. I can't figure out if there is a way to do this without having to manually add my own tasks to a sheet.
-
Addon to export data in particular format!
Hello, I want to export data of a row(s) in certain format, is there any addon available for the same. Expectation is that once the data is exported it will take automatically take a predefined layout in PDF for the report. I will appreciate if anyone can directly help me on this asap.
-
Data Meshing from a report to another sheet wipes out the data
I created a reported and I then exported that report into Excel and then uploaded that Excel into Smartsheets as it's own sheet. I want to be able to data mesh from the report to the target sheet, but even though it's identical information when I data mesh it wipes out all of the information from my Assigned To column.…
-
Global Update Find/Replace for a checkbox column?
I'm trying to run a Control Center global update to Find / Replace a value in a checkbox column. I want to find certain rows and if the checkbox column is unchecked, to check it. I've tried a few different combinations of settings, none of which have worked. See my screenshot for my most recent (failed) attempt. Any advice…
-
Smartsheet data in Power BI Date fields - Remove Timestamp?
When I import my Smartsheet data to Power BI, the start and end date fields consistently pull with a timestamp that is nowhere in my sheet. I need these date columns to just have dates, timestamps removed entirely, so that I can tell Power BI the data type is "date" rather than "text." Is there a way to do this on the…
-
I am new to Dynamic view. Can I create dynamic drop downs with it? If so how?
I have a huge list of employees with their associated manager. I want to create a drop down across all of my sheets for employee name and I want the list to shrink based on the state they are entering data for. Each state should only see it's own so I assume I have to create workspace for each state or does Dynamic View…
-
Best way to connect Smartsheet with SharePoint?
At the minute i am pulling in data via Data Shuttle workflows from my one drive to connect sheets and excel reports. What is the best way to change now to connect my sheets to SharePoint sites to pull data in?
-
Does Dynamic View Create a new row?
I have a sheet that contains nurse credentials. Each nurse has access to their row on the sheet via Dynamic view. So when their credentials expire, they can go into Dynamic view and update the information. But when they do this, it creates a new row on the sheet. While I love having the history, it is also a distraction.…
-
Can Smartsheet send files as an automated workflow?
We are trying to create a client "welcome packet". We are envisioning our team members completing a Smartsheet form, and based on what they select (documents they need), Smartsheet will email them those specific files. I'm guessing that's not possible, but I wanted to be sure or see if there is an alternative solution.
-
Data Shuttle - just want to add new rows
Hello! This is probably a silly question but for some reason I am really struggling with it. I want to just add new rows to an existing sheet.. pretty simple.. but for some reason the unique identifier requirement is throwing me off. What do I do in data shuttle to just add new rows from an excel file to an existing sheet?…
