-
Clearing data from smartsheet before data uploader runs
I have a smartsheet that I am populating monthly with a job from data uploader. The smartsheet has several columns that are manually updated between uploads. For example, January the uploader will run and import data to overwrite existing data in Rows A-C in Columns 1,2,3. Column 4 will be manually updated sometime after…
-
Excel Data Extract
Who has experience with Zapier (or another app) that will allow Excel data extract into an existing Smartsheet? Need more functionality than just whole rows. Too complex to accept creation of a new Smartsheet with each Excel data transfer. Data Uploader won't work. Would like to be able to extract individual Excel cells…
-
Setting timezone globally on account
We are based in Australia and when a new user is connected to our Smartsheet instance they automatically get US timezone set for them and need to adjust this is personal settings. Is there a way to have this globally set for new users as an admin? I have looked through the admin centre and it doesn't look like it is there.
-
How can I automate copying new rows of a sheet from smartsheet to sharepoint list or excel online?
Since there are no options to change the "reply-to" email for alerts/reminders, I am looking into using MS Flow to do the automated reminders. However, it seems like I don't have an option to directly get the cell details from smartsheet to MS Flow so I first need to copy the new rows from smartsheet to excel online or…
-
10,000ft Integration
Just verifying - we currently have a SS subscription; is the 10,oooft functionality an "extra ad-on" that we would need to purchase to achieve that functionality?
-
SR1 Error Message
I recently added a couple of new profile data to my blueprint and provisioned a test project to verify it. The project was provisioned with a note "Summary Reporting: no template attached to reporting sheet (SR1)". I check the project folder and the cells are all linked correctly in the sheets but the project is not added…
-
Linking multiple cells at once - from vertical in the source sheet to horizontal in the destination
Hello - I have a sheet that is a questionnaire with basic check boxes. The questions run vertically down a column, with the checkboxes in the adjacent column. I would like to link those cells, that exist vertically in the source, to a destination sheet, where each row is now a column. I can do this cell-by-cell. However, I…
-
Why is Dynamic View only pulling through one set of drop downs for a specific column?
I am new to using Dynamic View. I have three sheets that I combined into a row report and then have been trying to create my view off of that report. I have a column named request type on all three sheets and each sheets has different drop down options for that request type column. When I go to do conditional formatting…
-
How do I link a field in metadata to its metadata in a Blueprint
Hi, I have a Blueprint setup with a field "Risk - Open" in the Blueprint but not included in the profile data selection so does not appear in the Portfolio Summary Rollup sheet. but already exists in project metadata sheets created from the Blueprint. I have selected this field in the Blueprint portfolio data selection and…
-
How to select a different sheet to update a Pivot Table
Hi there, I still learning with pivot app. I want to update one pivot table selecting a different sheet, in other words, I need to change the data source. Is that possible?.. When trying to update, I see the option to select a sheet is disabled. Thanks in advance!
