-
Sheet to sheet selective data transfer (for new rows)
I currently have two active sheets. The first sheet, we'll call "intake" and the latter "Projects". If I review a *new* row added to "intake" and determine I want to copy it over to "Projects", I need selective data from certain columns on that sheet to transfer to certain columns on "Projects". The columns do not directly…
-
Forms
I am literally new to Smart sheet and feel very lost. I am trying to send out a form for meetings and then they would reply on SS as to wheather they were going to attend or not? I am notified of changes and the responses go to a different row and it does not show date of response or a name? What am I doing wrong?
-
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…
