-
Email content into a sheet
Box has a great feature where you can send an email to a specific box email account, and it will automatically put the attachments into the folder associated with it. It would be great if we could email a designated smartsheet email, and have it automatically add a line to a sheet with the attachment or content included.…
-
Document Control
I'm wondering if anyone has used Smartsheet to set up a Document Control process, and if you have any suggestions to how I might get started with that. I would like to have a form log that generates sequential form numbers as well as a way to keep completed forms with a single access point. Automated approvals would be…
-
New Template Sets for these Workflow Categories! Let me know your thoughts!
Hey everyone! As a Product Marketing Manager here at Smartsheet I am always thinking about how we can produce content that helps you work more efficiently. Especially now, we are producing new Template Sets that will help you and your organization work remotely more efficiently. Let me know your thoughts, but we are…
-
If statement in parent row to delete children row?
I am working on a sheet where a task is to validate a set of data. If the data fails there is a follow up task to revise, if it passes the next task is to launch. Right now I have these all set as rows. But I wanted to see if there was a way to insert a checkbox for pass/fail and then based on whether that pass or fail…
-
Forms that need to incorporate multiple line entries
We currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible As you can see from the attached files, the form is set up to add a new line after each previous line is filled in and the 'save' button pressed Are we able to set up a Smartsheet form to…
-
Is it possible to count the number of entries in a column for the current work week, and quarter?
Is it possible to count the number of badge IDs in a column for the current work week, and a quarter? I need to track the progress of a weekly target that resets every Friday. Currently, I can not get the CWs (blue) to align this is my starting point for all of our contract workers. Here is one of my sheets created that we…
-
Access for invited Team Members
When connected to my company's network, only particular team members can access Smartsheet. For those that cannot access it, neither the email invitation or direct login works. From the email invitation an error comes up that reads "This site can't be reached. The connection was reset". When attempting to access from the…
-
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…
-
How to Alter the "Sheet - IT Ticket Metrics"
I want to alter this sheet, found in the IT ticket Template, to just show the metrics for a specific customer. the original formula looks like this: =COUNTIF({Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1) and my attempt to specify to a single customer looks like this =COUNTIFS({Created Date Range},…
-
Emergency Preparedness with Smartsheet
Hello SS Community! Does anyone of examples of a Corporate Emergency Preparedness Checklist that one can share with me as a starting point? Tips greatly appreciated!! Thank you!