-
Is there a work around to capture modified by for a cell instead of the row?
Hi everyone, I’m working with Smartsheet’s Dynamic View and I’m wondering if there’s a way to automatically enter the email of the person updating a specific cell into another cell. I only need the email to be captured when a particular cell is updated, not the entire row. Modified by will not work because that changes any…
-
Control Centre Automatic Move Automation Rerouting
I have a Control Centre Blueprint that contains two sheets, let's call them Sheet A and Sheet B. Sheet A has a Move Automation that sends the row to Sheet B. I would like it to be that when Control Centre provisions a new set of sheets, let's call them Sheet A' and Sheet B', the provisioned automation on Sheet A'…
-
How can i make an automation to notify me 2 years before a due date?
I have a due date (e.g. 28/10/2027) and id like to be notified 2 years before the date. As smartsheet only allows me to set an automation 365 before a due date, I made a helper column which would bring back the date i should be notified. I used the formula below but i get an error. =DATE(DAY([Due Date]@row), MONTH([Due…
-
Automatisierungs-Workflows: Benachrichtigungen
Ich habe mir einen WF gebaut der mich bei Änderung einer Ampel informiert. Ändere ich zwischen zwei Speicherungen in 8 Zeilen die Ampel erhalte ich auch 8 E-Mail Benachrichtigungen. Ich möchte die Info über die Änderungen jedoch in nur EINER Mail erhalten. Eine stündliche/Tägliche Benachrichtigung ist nicht möglich.…
-
Automatically updating/adding rows from a linked sheet
I have created effectively a 'dummy sheet' version of a Smartsheet for my implementation officers to use to use to request an update form for their item. The rows in the sheet are linked to the more comprehensive and detailed 'Full version'. However, if I add another row into the 'Full version' it does not translate to the…
-
Trouble with understanding Workflow
I work for a company that runs clinical trials; I want to create a way to send out vendor performance surveys to Clinical Trial Managers (CTMs) who work with the vendors on different studies. Each CTM is responsible for one or more studies, and some vendors are repeated in different studies. The CTM needs to take a survey…
-
Auto Send Documents
Hi, I have created a smartsheet database to track new starters, based on fields when a "completed" status is reached, a document is generated filled with new user info. Is there a way to automate this to email to a user / contact assigned?
-
Changing a dates color once it is within 2 weeks
I would like to automate a change to my date column once we are within a month, 1 week, and once the date has passed. I would like these to have corresponding colors depending on how far out the date is. Wondering what options I have to do this? For example, I would like end dates colors to either be green if it is beyond…
-
Recording Changes made in SmartSheets - Row and Column Modifications
Hi Everyone! I was wondering if anyone knows any good ways to record a changed value in Smartsheet's, for the purpose of reporting it in Power BI? We are keen to understand and show the client what changes are being made to the sheet, by who, and what data is being changed (e.g. the status category to changed from…
-
Allow automation to populate cells with formulas.
For some reason the devs have blocked using =formula() and they populate cells with '=formula() when you try to use the features in conjunction. This makes your formulas inert and is quite frustrating. This seems like such a easy way to increase efficiency in the program and should be implemented immediately. Thanks for…