-
Enable Workflow Automation Repetitions
Hello Smartsheet community. I have created a workflow automation that will email a custom message to the contact(s) in a specified cell. This workflow must initially trigger when: There is a change in a cell, in this case "Lifecycle Status" When two days have elapsed since the cell change. If the notified user does not…
-
Total Time Spent On Various Sites
Hi I have a sheet that tracks time spent on multiple sites, I'm trying to add this to a metric sheet but struggling to get the metric sheet to add the total time spent against each site as a total. Can anyone help with the formula for this? Thanks
-
Red notification circle on navigation pane is not showing up when there is a new notification.
Hello, I have a user that has mentioned he is receiving email notifications, and the alerts are showing up in the notification center, but the red circle indicating a new notification within Smartsheet is not showing up when applicable. Any ideas as to how to fix this for this user?
-
Using Document Builder to generate multi-page pdfs (Doc Builder pdf + attachments)
Greetings All, I am creating a speaker database that will allow prospective conference speakers to complete a submission form and upload attachments for consideration. I've figured out how to use document generator to convert the info recevied via a form into a pdf which the selection committee can review. Is there a way…
-
How to Combine multiple inspection reports into one row
We have a complicated project where we're collecting rooftop inspections with one platform, using Zapier to push it over into a Smartsheet, and from there I need to move these inspections into Salesforce as leads with the Salesforce connector. The problem is, each roof section is coming in as one row. So we will have a…
-
Automation works correctly when manually changed in sheet but not when input through form
Hello, I created an intake form for a project request. In the form there's a field where the submitter has to select from a dropdown list of Contract Information choices. Here are the automation logic I have: When I tested it by selecting the different options in the dropdown in the sheet column, this works correctly.…
-
HOURLY reminder function
Hi everyone, I've been looking through dozens of post in the last couple of days to gain some insight on how to set up HOURLY reminders based on a status of a column not changing. I have not been able to figure this out as most of the references I am seeing are about Daily reminders and fields that have Dates in them. Here…
-
Post to Team Private Channels
We need the ability to post to Private Channels within Teams. We have project specific channels that are limited to the project team and do not want to make these channels public. I have seen many others asking for the same functionality so I think that this is a great feature to add ASAP.
-
Workflow is not triggering email notification
Dear community, i have created a workflow that should trigger an email once one of of the status: Low number of participants, or Cancelled by BPO under "comment for not attend" has been selected (see screenshot). We tested multiple times and we do not receive an email if we update the status to nr 1 or 2 mentioned above.…
-
certain cells remain locked until specific data is entered in another cell
I would like the ability to lock not an entire column or row, but just a single cell, and then unlock it when data is added to another cell. The solution could be implemented as a workflow.
