-
DataMesh - Updating ONLY new lines
Hi - we get two-halves of requests from separate parties, and I'm using DataMesh to link to things based on a Unique ID. Once the second half of the request is in the sheet, I don't need to update it again. Right now, my DataMesh setup is updating that row anyway - is there any way to ignore "old" or existing requests?
-
Multiple forms with unique dropdowns
Hello, I currently have a smart-sheet that gathers data from multiple vendors (each vendor has a form). One of the columns is an ID which would be entered through a drop-down. The functionality we are looking for is to have unique drop-downs for every form. Would this be possible? When I plug in the values for the…
-
Capture metric each day and add to new row
I have a number of Harvey ball metrics (count of red, yellow, green tasks) and things that change every day. I haven't really seen any way to capture and store these each day at a particular time (or hourly, weekly, monthly). Anyone have a good solution for it? Example of metrics I'm collecting on-the-fly from Control…
-
Disabling Field Logic?
Hello Community, I am sure this is an easy task but for the life of me l can't make it happen. I setup some field logic to make the user enter a date only after the condition was met, since this is a new process and user is still catching up with entering the data, we decided to disabled this logic so they can just fill…
-
Is Live Data Connector compatible with Windows Server 2019 & 2020?
Hi, docs say only through Win Server 2012, hoping documentation out of date. Thanks
-
Time Formats - Number formats - Rethinking the UX and function
Having an entire dialog for text and number formats would make much more sense to me.. combine the currency, percentage, thousands and decimal places into it's own dialog box. We really NEED a way to save and modify the formatting of common things. So as to have them available and globally modifiable across workspaces. Use…
-
Automatically copy data from email into Smartsheet
I am building a Smartsheet that will track work items for a group. One of the ways I need to have work items added to the sheet is via email. I want this to be automatic (fully automated) so that no one has to open the mail account and copy the info into Smartsheet. I looked at Outlook for Smartsheet plug-in, but it does…
-
Power BI Desktop Refresh Issue
I got Power BI Desktop to load graphics into a dashboard. Only problem is that I have to login too often. Is there a way to keep the graphs always open in the dashboard?
-
Smartsheet and Procore Integration
Has anyone used Smartsheet hand in hand with Procore? Background: My company is the design team on a construction project. We are using Smartsheet to handle workflows and documents questions from our subcontractor. The subcontractor is managing the schedule and is using Procore for that piece. Does anyone have any examples…
-
Microsoft Forms and smartsheet column types
I used to use Formstack but my company is switching over to Microsoft Forms. I'm having an issue where I get a Microsoft Flow error message when I try to map the Forms Timestamp to a smartsheet column that is "Date" format. This is the error message I get: "The value for cell in column 6900857162753924, 4/10/2020 12:14:09…
