-
How to capture/log user/contact info in a cell after updating a different cell?
I want to be able to identify the user when changes are made to cells on the Sheet. I know there is the Activity Log. But I want to see that data on the Sheet. I also know that there is the Modified By column, but that picks up changes to any cell in that row. I have a log that needs to have the status column changed by…
-
How to set up an email reminder 7 days after creation date
Greetings, I'm trying to set up an automation to send an email 7 days after creation date but I'm having problems. I tried using the function =IF([Creation Date]@row) > TODAY(+7), 1, 0) but it isn't working as expected. When I change the date with a test date from a date column, it works fine. Any ideas what I am doing…
-
Project-based timesheet approval + automatically add team members to a project
Issue: For a Project-based timesheet approval flow it is necessary to add the team members to a project. A Project Owner needs to add someone to the project first to be able to see their time submission. Booking someone for a project for the first time, would make this person a team member. However, RM isn't handling this…
-
I'm the owner of a number of sheets and used to be able to email forms, but can no longer do so.
I have been able to create a number of forms and I used to be able to send email notifications to people to complete them. However, I can no longer seem to send the emails although I can share a link. We are on a business subscription and I'm the owner of these sheets.
-
Help for Status Change and Tracking
I am trying to create dashboard widgets from data that I am tracking. For this widget I am wanting to have a graph show the number of people in each status section I have listed: "Not Started", "In Progress" and "Completed". Each employee has an individual sheet with tasks listed along with corresponding start/end dates,…
-
Smartsheet Update Request Automation to Alias Email Address
We are running a automation for an update request to a number of email addresses and it runs fine with the exception of two which happen to be alias email addresses. Has anyone had this issue with them not running and know how to fix it? We after the automation didn't run we ran the update request manually and it ran as…
-
Placeholders in Message field for Update Requests
When creating a message for an update request, I am trying to make an automation for general use. Within the message I tried to include {{Customer Name}} where Customer Name is a column name. I was reading somewhere that this should be able to pull in the details from the Row the update request is being sent for. However,…
-
Date selector
Is there a method to enable clients to choose available dates for meetings from a dashboard or a list displayed on the dashboard? Our objective is to develop a form that presents clients with open dates for meetings, allowing them to make their selections.
-
Quickbooks & Smartsheet
So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use. It has many application & the proof of concept exists and we use it. We use it for an approval process (for invoices): The power of Smartsheet i.e. (approvals, communication, notes) makes this a beautiful…
-
Work Flow and Automation help
I am attempting to set up a workflow sheet between operations, sales, and owner. The idea would be to have master sheet where information is fed to it through multiple sources. Once the master sheet has all of the data needed it would then feed to sales and the owners to give them a snapshot of their work. Is it possible…