-
Data Shuttle converting mmm d, yyyy date format to numerical value
Hello Everyone, I have a Data Shuttle workflow that has been run virtually every business day for over a year. When running today, four columns of dates converted to numerical values. No formatting of the source sheet has changed (Excel file with a Custom category of mmm d,yyyy Cell history confirms date format used to be…
-
Form that can perform math
Hello - I would like to use Smartsheet to collect resourcing information. Specifically, I would like to send a form once a month to each employee, and ask them to specify the percentage of time spent on each project they work on. For example employee 1 would enter Project 1 0.5, Project 2, 0.3 Project 3 0.2. The…
-
task status update from slack to smartsheet
This discussion was created from comments split from: Slack Integration.
-
Additional MS Office and enterprise intagrations
Hello - apologizes if this has been asked and probably has in different ways. Is there a product roadmap that details upcoming and longtail implementations of other Office product intagrations. Or for that matter, other platforms that will be integrated and work with SmarSheet? I am responsible from moving our Program…
-
Updating Project Schedule dates using Excel Spreadsheet (duration causing issues)
I have a schedule that is thousands of lines long. I have a .xlsx file with my unique identifier (Schedule Item #) in one column, activity description, start, and end dates in my file. My Smartsheet settings are set to automatically calculate the duration of the duration in a separate column based on the start/end dates.…
-
Data Links | Column Links Feature
Anybody know when the below feature will be released? This will be huge in, eliminating the need to create detailed, stacked formulas (index/collect, etc.). As Smartsheet continues to streamline data connections, we're also making it easier to connect data within Smartsheet itself with the upcoming data links feature. This…
-
Bridge: Automatically backup a workspace using "Save as New"
Would anyone be wiling to share their Bridge Workflow and Script that automatically backs up a Workspace by using "Save as New"? I hope there are many of you with a solution like this since Smartsheet's backup option is very limited, whereas "Save as New" preserves EVERYTHING. Please and thank you!
-
Why is my report removing specific sheets?
Hello Smartsheet Community! I hope you can help me with the below. I have a portfolio reports folder that includes a report called MY Tasks. New projects created via the control centre are automatically added to this report so that you can view all your tasks for each project in one place. I then added two additional…
-
Update multiple column dropdowns on one sheet, from one source sheet using Bridge
Hello! Bridge newbie here. I have successfully set up a Bridge to update the column dropdown for one column from one source sheet. I'd like to build off this bridge to update multiple columns dropdowns on the same sheet, using the one source sheet. Is this possible? Here is what we have set up so far. @Genevieve P.…
-
Loading SQL Data into Smartsheet?
Is there currently a way to do this? We have very good integration from Smartsheet into our data model, but currently have no way to populate columns in Smartsheet with live data from SQL/Fabric etc. I saw this thread, but it does not look like there was a solution at the time: Can I populate Smartsheet rows from a SQL…