-
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…
-
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.
-
Advanced Search Functionality
Hi All, It seems as if you are unable to search by a row # or an advanced function in Smartsheet. For instance, if I have a customer that has multiple requests, when I search, I am unable to tell which one it is for, and I need to click on each of them. Is there a way to advanced search by the reference # that I have set…
-
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…
-
Web content pages in WorkApps
I have been exploring WorkApps and I have been able to setup Smartsheet Content Pages, Create roles, add users and set permission for the Smartsheet Content Pages. Love this, but when I try to add Web content pages I am unsuccessful. I give the web content a name & add the web content link (example I added YouTube as page…
-
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.
-
Create a form from Smartsheet data
Here is an odd idea that we want to determine if it will work with Smartsheet. Our associates should be able to fill out a form and send it back to our offices, where it will immediately update in Smartsheet according to the entered categories. We are hoping we can then pull this information by monthly update to present on…
-
Overlayed Calendar Publishing
Hello, I have built a calendar overlayed with another calendar from Google. I am looking to publish the overlayed calendar view in the dashboard, but when I embed the code, only the calendar items I've added into the dashboard are populating. Any advice?
-
DATEONLY Function
Hi all, I want to extract only the date from below-mentioned Date & Time format & then use it for computing the duration of certain activity. 08/28/2023 02:45:17 AM PDT DATEONLY formula is not working with this Date-Time format. This date & time format is extracted from our ERP system reports & can not be changed. Can…
