-
Reverse Geocoding
I am using a form with the pin drop to track sales employees in person visits / cold calls. The return value in my data sheet is the location coordinates hyperlink that takes you to Google Maps. Is there a way I can extract the address information from the coordinates into a separate column on my sheet? I have an…
-
How to get an alert for these criteria?
I tried to create a notification/alert but I cannot seem to make this work. I (as the owner and admin of the sheet) am trying to create an alert/notification when certain column data is left blank. For instance, I can add a row with a task activity on my project plan, but sometimes I'll forget to update the "workstream"…
-
Alert Someone Automation
Hi all, I am attempting to set up an automated workflow for account collections. A single sheet will include cash collections for multiple clients. I have RYG triggers set up to run alerts on the 5th day once and then recurring daily on the 10th, no problem. My issue lies with the contacts. I have separate contacts listed…
-
Email automation with "Assigned To".
Text translated by moderator as per community is currently only supported in English, Spanish, German and Japanese. Hello everyone, I hope you are well. I have a question about an automation in my project sheets. One automation I'm implementing is an alert for when a certain project activity is approaching its due date. To…
-
Project Collaborators Schedule Report
Hello everyone, I hope you're doing well. I'm new to SmartSheet and currently working on my initial projects and automations. I have a project group and would like to create a report in the project management office that allows me to identify all the collaborators involved in each project and in which months they will be…
-
Automation using reference cell
Hello everyone, I hope you're doing well. I'm facing a difficulty in setting up automation. In the project model we've adopted, one person is responsible for monitoring the project progress, and this monitoring is measured as the stages are marked as Complete. This calculation is straightforward with a formula that…
-
API call for RowID
Hello, I am working on an automation where I need to get a row ID number. I'm starting with the unique value in a Row ID column called "Row", so I think I need to search the target sheet for that value and return the row ID number. I would like some help structuring the API call. The format of the unique number in the…
-
Smartsheet Backup and Recovery
We would like Smartsheet to provide a mechanism to do a full backup and restore of related files. While a step in the right direction is the ability to restore to a previous version of a sheet, we find that in an integrated environment, this would not be sufficient: We have a single worksheet that drives multiple reports…
-
The automated workflow to enter the PO number when a status is reached does not work well
I have created an automated workflow to ask requestors of spends to enter the PO number when the spend request status changes to approve. When I run the automation, not all the requestors with the conditions I specified are receiving the notification with the link to the form to enter the PO number. Let me know if you need…
-
Sheet Sharing / Default View
Quick question on setting a Default View when sharing a sheet. I have a sheet that contains employee information that requires quarterly updates. Currently we are NOT sharing the sheet due to sensitive information contained in the sheet. This means a report for each supervisor to edit their employees will not work because…