- Import Date column to google doc with my formate
我添加了内容扩展/插件咕gle Doc . The DEFAULT column formate in smartsheet is the formate imported to google doc ( ex 23/07/22) even if i change date formate in smartsheet to other formates of my preference stilll the default formate is imported :( Is there a way to import my preferrable date formate…
- Exporting group members
I'm wanting to do a review to make sure I have everyone placed in the right buckets. I can dump a user list but there's no group membership details included. I don't see any automated way of dumping group members to CSV for review. The best solution i found is stupid -- open each group and copy-paste the html into excel…
- Workflow from Harvest
Hi, I have time logs being imported from Harvest from multiple projects, I then want to split this data again using workflows into separate sheets with relation to a specific project. Eventually I want to roll this out between a team of people (around 10 people). Is this possible as I have other workflows that work fine,…
- Is it possible to have data automatically inserted from an image by image recognition?
I see that Microsoft excel has the ability to use OCR to insert data from an image so I was wondering if it was somehow possible to integrate a working version of this into a Smartsheet. Thanks in advance.
- Export to Excel loses hyperlinks
I've read a lot about how hyperlinks hidden behind texts will not export to Excel from Smartsheet. Are there any workarounds for this? I have a report that collates 170 schedules, and the Sheet Name column contains a link to each respective sheet, which is great, if I remain within Smartsheet. However, we are using Power…
- Import Excel file and include embedded images
Hi, I was not able to find a way to import an Excel file that has images embedded in cells, and keep those images when the import in complete. Is that possible? Am I missing something? Or do I have to re-import those images manually, one-by-one? Thanks in advance.
- 3 Month Compliance Tracking
Hello SS Community! I've read lots of answers over time but never asked my own question so here goes nothing! I need to create a tracker for individual employee Compliance for training. We have many tests that each employee performs, but they must stay compliant within 3 months. They can't go 3 months without doing one…
- Smartsheet and Business Central integration
Hello All, I'm trying to integrate the Business Central projects table with the Smartsheet. I want to create a new project sheet in Smartsheet whenever a new project is added to the Business Central. However, it seems the Create a sheet option is not currently available with the PowerAutomate. Did anyone face the same…
- Report with image of attachments
Hi Everyone, Is there a way to create a report that shows the image of the attachments? We have a quality control sheet that new items get added through a form along with a picture. I would like to create a report that can show the picture next to the fields associated the punch list item. Another way would be to export…
- Refund Tracking Smartsheet- Ideas or Template
Good Afternoon Everyone, I am overseeing customer refunds for our company. Our company requires customers to make a refund preference so when there is a refund due to them, we can deliver it to them as quickly as possible. However, because many of them do not make a preference the customer refunds are returned by our bank…
