-
Getting trigger itself error in Smartsheet
Hello Everyone, I hope you had a great New Year! I have one (Source) sheet in which data is coming from Google sheet through data mesh and based on certain conditions it will transfer to the specific sheet. Once the data is added to the sheet and the team feels the information should be on another sheet I have provided a…
-
When sending an automated email, is there anyway I can pick which order the customized fields go in?
Each time that I try to put certain fields from the sheet into my customized message in a certain order, it keeps changing it to something random.
-
Automation not obeying conditions?
I have created an automation to send reminders for an Actions Log. The workflow is as follows: Run every day at same time If "notify" field is checked Various date conditions, eg due today, due yesterday, due tomorrow Send email depending on branch selected in (3) Not all of the action items have the notify field checked.…
-
Send alert when user hasn't accessed sheet in X days
Hey there - I'm trying to set up an alert redirecting users to my sheet to make sure everyone's using it and gently nudging them if they aren't. Here's the logic: IF they a) have permissions to access the sheet AND b) haven't accessed it or changed anything within the last 20 days. THEN Send a message including a link to…
-
Mapping data within a hierarchy
Hello, I hope you are well. I'm trying to find a way to collect information within a hierarchy on a sheet. I need to gather the last date for a column within a level of the hierarchy and display this date in the parent cell of this hierarchy, regardless of whether new rows are added during the project's development. The…
-
Control Center Work Around
I have set up a very simple control center program to generate two sheets for every freezer we have on site at my research facility. One sheet is meant to house active inventory while the other is meant to be an archive sheet. So, when inventory on the live sheet has been discarded we have record of it on the archive…
-
Cumulative record of live sheet summary reports
Hi everyone, I have a sheet summary set up on every project, which tracks a number of weekly KPIs - e.g total tasks that week, total completed that week etc. The sheet summaries feed into a larger sheet summary report which shows these KPIs, but only for this week. I'd like to capture the info in the sheet summary report…
-
Update assignments in template based on sheet
How can I assign ownership to tasks based on contacts in a sheet? For example - I have a list of contacts that define the owner of each area for every project. As I am creating a new project from a template, I would like to lookup the owners for the tasks based on the information in the sheet. Example - project below would…
-
Automating Cell Link
I've created a workflow to handle project requests that come in to our department. We have a master sheet where all new requests are entered (either manually or from a webform) then each of our 3 team members have an individual sheet. When the new project is assigned, the row is copied to the individual's sheet (to whom it…
-
want to create a tally sheet
Hi all thanks for any assistance you can offer I'm trying to create a tally sheet that reads from a couple column in another sheet and counts each individual answer. So the first column is "contact person 1" and i want to be able to have the sheet count the numbers for each person in the contact person 1 column and then…
