-
Concatenating values from two columns with 20 spaces between them
Hi guys, I have a task to concatenate two strings from two different columns with formula. The values are for example SEA129 and 01. What I want to achieve is a string which will look like this "SEA129 (20 blank spaces) 01" Has anybody encountered similar issue?
-
When setting up alerts to send to MS Teams, Im getting the Approval required message
When setting up alerts to send to MS Teams, Im getting the Approval required message, May I know who does this goes to, is it the MS Teams Admin, MS Office admin, or Company Smartsheet Admin? And where can I find that?
-
Total Hours with the same person assigned
I have created the below sheet. I am trying to total the hours used for rows matching "person" E.G In the first row "Richard Irwin @ FM" I'm looking to total the rows below Project Staffing that have Richard attached to it in the column "Person" Any ideas?
-
Can I copy cells to another sheet without creating duplicates?
Hi everyone, I'm looking for some help with automation. STEP 1: I want to copy row data from one sheet ("Sheet A" for simplicity) to another sheet ("Sheet B") when a status column is changed to green. STEP 2: I ALSO want to copy row data from "Sheet A" to "Sheet B" when an attachment is added. By nature, STEP 2 will happen…
-
Use Custom URL to add users to company account.
Use Case: 1. Account Discovery is enabled for company. 2. A user received a shared Smartsheet from a company Smartsheet owner. 3. User clicked on Smartsheet, and it sent him to main screen to create an account. 4. User created an account using his company email. 5. Smartsheet associated his account with the company. 6. A…
-
Microsoft Teams - Multiple Smartsheet Notifications via Automation to a Public Channel
I have created automations in Smartsheet (SS) to send notifications to a public Teams channel in my organization. This works flawlessly without any issue. I have another separate sheet in SS with a very simple automation that when a row is added to a sheet (via a form), it is to update the same Teams channel as the one…
-
Weird Trigger action on workflow automation
I have a workflow automation on sheet 1 that copies a row from sheet 1 to sheet 2 and sends an alert to my email when it is done. The cell that triggers the automation (a checkbox in sheet 1) gets populated by another sheet (sheet 3) and as such the rules say that the workflow will not be triggered and the row will not be…
-
Do users have to login to receive notification emails as an automated workflow from a sheet?
I have an author schedule for a weekly blog that I would like to use to send out an automated reminder email to the assigned author each week. They don't need to go into the sheet to update anything, it's just for me to track. We are in the process of creating SS accounts for each author but I want to make sure I'm giving…
-
Are there workarounds for Autosave prematurely triggering automations in Board View?
My PMs are noticing that Autosave in Board View is triggering automations for sending the assigned person updates on their tasks before the PM has finished making updates to all necessary information on the card. This is causing folks to receive incomplete information in their assignment notifications. Is there a way to…
-
How to identify if a checkbox has ever been checked
Good morning, friends of Smartsheet, I need some help working through a process. I have a worksheet that has a checkbox column called 'escalate'. When we check that box, the row shows up on a report that our Compliance group can see, so they know their assistance is needed in some sort of communication efforts. Once the…