-
Data Mesh Not Mapping Correctly
I am trying to do a Data Mesh between two sheets, and it doesn't seem to be mapping correctly. I think this is an issue with the lookup values, but I am not positive. On the Target sheet, the lookup value is the Primary column and there are many multiples in that column. Could either of those factors be causing problems?…
-
How I can extract the creation date and time of a Jira ticket into Smartsheet
In Jira, the creation date has the date and time of creation, when I call from smartsheet the creation date I can only get the date, but I need the time too, the same thing is happening with the Date updated field. How can I get in smartsheet the date and the time for these fields? Thank you in advance for your support…
-
Dynamic View Saving has Changed?
I have required logic at the end of my detail panel that is present if one question above is "Yes". It is currently allowing saving without answering that question and then allowing exiting without completing the required question. This behavior seems to have started today. Is anyone else experiencing a problem with…
-
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…