Looking for solution for Forms to add multiple rows to a sheet
I have a problem that I'm trying to find a solution for. We are looking to collect Patient Day information from up to 180 Hospital facilities for them to be able to report on # of days per unit in their facility. There could be up 20+ units that users would have to enter data for and completing individual forms (20 times)…
DocuSign Integration Errors
I had no issues with generating a Docusign document with 4 signers until the last time I updated my Smartsheet app. Now my main sheet has no issue with sending out a document until I try to add more than 2 signers. I get the top error shown below. I had the idea of saving the document as a draft and sending out manually…
Update reporting for Active Projects
Hi, I've searched extensively and can't find the answer to my question in the help section. We have a blueprint in control centre, which has produced approximately 400 active projects. The template is 5 subfolders, 4 sub-sub folders, and 46 sheet/report/dashboard templates. We have a number of rollup sheets and dynamic…
fix the color of the outline on dark background cells highlighted by the find cmd
Hello, We noticed that the highlighting of a cell resulting from a found occurrence (find command) is barely visible on dark backgound, especially blue. I noticed that on a smartsheet the outline is blue, and on a report the outline is some kind of grey. Would it be possible to define a different color, more visible, when…
Attaching a document to an Alert
Is there a way to attach a pdf to an Alert when you are creating an Automation? If not, does someone have a workaround? I need to send a pdf of the Guidelines to Supervisors once their email addresses are added to the sheet. thank you!
How to extract data from Outlook
Hello, I'm hoping someone smarter than me might know of a possible solution to automate some data entry. I get emails in the following format and I have to manually enter the data into Smartsheet via form. But, I can get a lot of these throughout the month and I'm thinking there must be a way to extract this data from…
Multiple % Complete Columns?
Hi all, Overview: I'm looking for a way to have more than 1 '% complete' column in a sheet Application: I'm building a project compliance matrix which will have a row for each requirement, and multiple columns for associated tasks. I'm not using this as a schedule / GANTT, but have turned on dependencies as this allowed me…
Trainer scheduling template
Hi all, I'm having a bit of trouble trying to come up with a template or ideas for how my training staff schedules look. The company hires people and then I schedule those people with my trainers. I'm currently using excel and I have tried to import my schedule. It looks awful and is very hard to read and understand (The…
Activity log of all smartsheet usage under my admin
Is there an API now or some way to find the last time a smartsheet was accessed? I don't want to have to traverse the settings behind each smartsheet and export a report one-by-one. I didn't see any recent threads about some API access to that information. Thank you!!
New to Smartsheet Tips?
Just started a new job. Company is new to smart sheet. Right now I work in data entry and basic automation. Eventually working towards full processes and product creation. Does anyone have any tips or tricks that I should know to help work through it. So far I enjoy using smart sheet and would like to learn more.