-
Power Automate - Post Attachments to Row/Sheet
Hello everyone! I spent WAY to long looking for this answer so I thought I would share it with the Community in hopes of helping someone else. Problem: Adding attachments to rows/sheet is not possible through the standard SmartSheet Connector Solution: This can only be done by creating a Custom Connector. It CANNOT be done…
-
Smartsheet Calendar unable to update health status on source sheet
Hi, I created a Smartsheet calendar organized by Phase and then Workstream, with deliverable bars spanning duration. The goal is to create an interactive Gantt chart, which team members can update tasks on the calendar detailed side panel. The formula on the source sheet states that if At Risk is checked then Health is…
-
Cannot get Automations to work the way I want
I'm trying to set up an automation for a task tracking sheet. I would like to send a weekly email notifying team members of their follow-up items for the week, and if they do not have any tasks, then they would receive an email stating as such. I have tried using the "otherwise" function, creating a second condition path,…
-
With the same trigger condition, the alert works but the assign people doesn’t.
Hi all, I created an automation in Smartsheet that triggers when rows are added or changed. If I set the action to Alert someone, it works fine. But when I switch the action to Assign people, nothing happens. I’ve already tried adjusting the workflow, but the assignment doesn’t seem to go through. The alert action under…
-
Errors/incorrect email addresses in approvals, request updates, notifications - bounce-back or alert
Hi there Is there an alert, notification, or 'bounce-back' is an approval, notification, or request update is sent to an incorrect email address or to an address that no longer exists? We have a request form in which our users need to include the email address for their Department head for approval. We have automation set…
-
Allow System Admins to View and Manage All Active API Tokens Across the Enterprise
Description: As a Smartsheet System Admin for our enterprise account, we need the ability to view, audit, and manage all active API tokens created by users in our organization. Currently, admins have no visibility into which users have created tokens, when they were created, what they’re used for, or whether they’ve…
-
I'm afraid this solution doesn't exist but...
I need to assign a unique identifier to jobs that we budget/bid. Since jobs tend to be budgeted/bid multiple times prior to landing the work, we want to be able to see all labor costs associated with a job throughout the life of the estimating process. The problem here is that budgets often times are requested under…
-
Primary column data to other Sheet
I have 2 sheets, Sheet A has Primary column and I want to copy Sheet A primary column to sheet B. Sheet A has 2000 lines in primary column also whenever I update Sheet A primary column I need it should be updated in Sheet B too. how I can do this in Smartsheet?
-
Best way to pull data from different columns into one
I have a worksheet that is populated via a form. Worksheet is currently 300+ columns wide (I didn't build it, I inherited it). The form is used by facility management technicians. Each time they go to a client site to service facilities, HVAC units, refrigeration units, etc. they complete this form. Yes, they complete in…
-
Automate reminders for Update Requests
I would like the ability to automate reminders for pending Update Requests where the user has not yet responded. When the user submits the update request, the reminders would stop. Ideally it could be built into Automations to select pending update requests and send a reminder after X days or within X days of a due date,…