-
Running Total in Pivot Table Smartsheet
Hey! I have a form linked to a sheet, and everytime someone replies to the form they are "raising a question". We have people working to solve these questions, and once this is done they change the status of this question to "answered" by checking a box in the sheet. I have the following columns: (1) Form submission date…
-
Microsoft Office 365 Planner support
What I'd love is for an assigned task to create a new Planner task and be linked together when changes happen to either side they update each other. Primary use case is that the majority of people who will access Smartsheet in our company will have other tasks they need to keep track of in the organization through Planner…
-
Custom Report Format Possible?
I need to be able to generate a simple format based on the data that exist in smartsheets. I store information such as news updates and I would like to be able to create a report that generates the text formatted in a specific way. For instance if I have the columns and 3 rows. * Publish Date * Category * Title * Body Text…
-
Mail Merge with Google Docs: combine into one file
I'm doing a mail merge using Google Docs, which works fine except when I try using 'combine into one file'. I've seen a previous discussion where the pagination was an issue but mine is fine except it changes the font! Can anyone tell me where I'm going wrong? Thanks!
-
Web content widgets in dashboards and PDF files
Does Smartsheet not support embedding PDF files into dashboards? Looks like Adobe XD CC is supported but I'm not familiar with that tool. Does anyone know how to get a PDF containing hyperlinks uploaded/embedded into a Smartsheet dashboard? I'd also like to retain the hyperlinks in the PDF so that viewers can still…
-
Android app - iOs app - is there a Windows app?
I use a Surface for work and wondered if there is a mobile Smartsheet app for Windows? I didn't see one in the app store, but though I would ask anyway. Thank you
-
Connect Smartsheet to Microsoft Power Automate (Flows)
I want to use Microsoft Power Automate to update Smartsheet and create a couple of documents from the same info (and save myself entering the same info three times!). I used a template in Power Automate which brought up two links to let me make the connection to Forms and to Smartsheet but the Smartsheet one didn't work…
-
Import to smartsheet is unable to auto-assign tasks - any plans to address this?
Dear Smartsheet, The issue - import of a google/excel sheet containing an "Assigned To" column fails to assign to known smartsheet users any of the tasks listed in the file that was imported with matching user names/email addresses * The specific problem is that even though the name or email address values in the file…
-
Pulling in data from external source
I work with large data sets on parts (60,000 SKUs) and I have a form and workflow for processing special pricing requests from our field. I'm curious if I can house the prices on an external excel file or sharepoint and pull in the pricing for an individual part. Since Smartsheet limits the row count to 5,000 I can't just…
-
Is there any possibilities to get the Webhook data when someone make a request to access the sheet?
Hi, we are using Smartsheet's webhook API. We have the following use case. Consider user 'A' registered a webhook on a particular sheet. When some other Smartsheet user 'B' who has URL of the sheet of the user 'A' and tried to access the sheet its shows "Request Acess" and when the user 'B' clicks on request access, the…