-
How do I include field changes in an email (Automation Question)
Hello: I am creating automations for several of my SmartSheet projects. I have successfully created an automation that alerts me when there are changes to any of 5 critical values in a row within my sheet. However, I am trying to determine how to include which of those 5 values changed in the alert email.
-
User Interface to collect smartsheet data
I have a smartsheet with data, I would like create a UI for other people where when they just type one of the specific data (such as name) and information about that row pops up without even opening the smartsheet. So it is easier and quicker to retrieve data.
-
Replacing form entries instead of copying
I have a smartsheet with a form automation that collects information like a survey. However I want to make it so when an entry with detail such as name is already in the smartsheet it replaces it with the new form data rather than creating a new entry.
-
Parent Task to Child Task Automation
Quick Question; Is there a way or work around in automation such that when a child task is past due, the parent task status can move to "At Risk"? Seems like something that should be simple, and maybe it is, but I'm not able to develop a work around. Thanks in advance.
-
How do I make a form field's visibility dependent on 2 fields?
Hi, I've been struggling with this with my favourite AI for over an hour now and I've hit a wall. I want to implement the following: if [CheckboxA] show field 1 if [CheckboxB] show field 2 if [CheckboxA and CheckboxB] show field 3 There is no way to do this within SmartSheet forms. You have to have a helper column in the…
-
Sheet modifiedAt
Hello, I found that sheet modifiedAt field in "List Sheets" GET method sometimes is different than modifiedAt field from "Get Sheet". Is this normal ? When I change a value in a cell, Get Sheet method returns the last modifiedAt date but List Sheets remain with the old value.
-
Rolling and Automated Inventory
Hello Smartsheet Community! I've been attempting to set up a rolling and automated inventory and have ran into a mind splitting concern. I've been able to set up a Master Inventory, Incoming/Outgoing sheet, and a Rolling Data sheet to speak to one another with notifications to notify when a currently stocked item needs to…
-
Automation and Forms
If i have a Microsoft template that i have to collect information and fill out. If i created a form to collect the information that's needed for the Microsoft Template, Is there a way to utilize the information from the sheet to automatically fill out that template and email it out to respondents on the list?
-
Is it possible to do?
I have to ask as I am hitting a wall here. I want to create a resource/solution where people can claim things : The work flow consists of Two parts. Section A and Section B. Section A (completed already) Section A is form where User A fills up to show/post what's available to claim from recently added items which I will…
-
Recipients of an automated workflow notification are not receiving emails
"Hello Jake, a recipient isn't receiving alerts from Invoice Status Update" notification We created a form that feeds into a grid sheet and it has automated workflow to notify users from a cell (client emails) when criteria like "Received" and "Completed" are met Most of them work fine, but we have a group of them which…