-
Tempo Account Field Not Updating in Smartsheet
We are working with a JIRA instance that is connected to Smartsheet and writes data both ways. The JIRA instance utilizes the Tempo Timesheets add-on. One of the fields in a Smartsheet contains a column that is mapped to the Tempo Account field which is a locked, single select custom field in JIRA created from Tempo. This…
-
Smartsheet slow response
Hi, I would like to know if you are also experiencing that Smartsheet is slow today (Sept. 21, 2017 - GMT+8) Thanks
-
Can I choose the choose the destination sheet for Google Smartsheet Sync?
I'm using a Google Form to populate a Smartsheet via the Smartsheet Sync. I had to unlink the destination Smartsheet (Sheet1) and then created a new link to a different sheet (Sheet2). I'd like to relink the Form so that all responses filter back into Sheet1. Is that possible? Thanks!
-
Can I perform proximity searches based on a contact's ZIP Code?
I'm trying to conduct a query that will return all of the contacts within a geographic area based on their ZIP Code? For instance, if we have an event in Chicago and wanted to get a list of everyone who lives within 60 miles of the 60602 ZIP Code. Our previous database application had this functionality, so I know that…
-
Smartsheet and HIPAA
Hi Community ... Sharing a bit about HIPAA from the team who helped implement Smartsheet's HIPAA guidelines. Here's the very short synopsis: Smartsheet does not collect or store PHI as part of normal business operations; however, any HIPAA-subject organization with an Enterprise plan that works with PHI can enter into a…
-
Help with a formula
Hello, This is probably a basic question... I am wondering how to input a formula that would allow me to calculate the value/price of something based on a drop-down selection. For instance, column A would have a drop-down options listing different tree species. For example, Redwood, Elm, and Walnut. Column B would have the…
-
Weekly columns
Hi there I think I am missing something here. I want to set up a list of tasks which will be due in certain weeks of the year and are repeated. For example. * Review website pages... Second week of each month * Write a blog article: Last week of the month * Post Facebook update: Each week. Do I set up 52 columns with the…
-
Reminders needing the same logic as Notifications
I've found a limitation of the reminders and notifications and would like to request that one or the other be tweaked to solve my problem. I want my contacts to receive an alert before/on/after a date but only if another columns checkbox is unchecked. Originally, I thought that a notification would work. I set up many…
-
Smartsheets for medical practices
Does anyone know if smartsheets solutions can be used to manage medical projects? This would include documenting information that would flow via api into an existing enterprise system.
-
Count Past Due Tasks
Hi there - I'm new to formatting / formulas in smartsheet (and excel for that matter) and haven't had much luck creating a formula that counts tasks that are past due. While able to use conditional formatting to visually identify these items I'm trying to roll this up into a project overview; the overview/dashboard -…