-
IF/AND formula based on a drop down column if the cell is blank
Hi All, I am working on a formula to trigger my at- risk flag based on the following information. Raise the flag if the end date column is less that 1 day away and the status column is blank or Not Started. Here is what I have so far. =IF(AND(Status3 = "Not Started", [End Date]3 <= TODAY(2)), 1)
-
Is there a limit to the number of fields I can use in a trigger for an automation?
I have a sheet that has 50ish columns and I need to copy a row (for archiving purposes) when one out of 25 columns for this row is changed. It seems like there is a limit to 20 triggers per automation - is this correct? Is there a way around this limitation? Yes, I could create one automation with 15 and another one with…
-
Automation function acting weird. Need a solution
I have an automation work flow that alerts my people of projects due within the week. Instead of the email showing it came from "automation", it is showing to come from other team members: This happens on my other automation workflows on other sheets as well. Is this happening to anyone else and is there a solution to…
-
Hierarchical numbering patterns?
Anyone with experience setting up hierarchical numbering schemes? I want to add a column that is hierarchically auto-numbered such that child rows are added to the numbering scheme as increased decimal points. For example 1. Row 1 --1.1 sub item of row 1 ---1.1.1 sub item of row 1.1 ---1.1.2 sub item of row 1.1 ---1.1.3…
-
Integrating Smartsheet with my app
Hello, I am working on a web application that manages projects for my company. Our salesmen use smarthseet to put in new projects requests, then we have a team that uses the data submitted by the salesmen to manually create these projects on our web app. My management is looking into automating this process, hoping to be…
-
Parent function to auto-populate cells
Hi everyone, Wondering if someone could help me with a formula to auto-label cells. I'm creating a project tracker for my team on Smartsheet and have automation set up for approval process, and also so completed tasks are moved to a new sheet. The problem is, on both instances, the row itself might not contain all…
-
Automated workflow log
Hello, Is there a way to see a when an automated workflow is triggered in smartsheet? Specifically around the time sent and who the recipients were. When I check the activity log, I can only see when a automated workflow has changed. There has been a few cases where an automated workflow doesn't send out to the particular…
-
How you do get an automation to send an "Alert Someone" email.
-
Weekly tasks automation on task management
Hello, I'm optimising a task management sheet with automation and would like to know if there's a way to use automation to create a row? Some tasks are weekly, and it'd be great if they could be automatically added in every week, so the owner can get notified and mark them as completed each week. Is this possible?
-
How to automatically copy the approved documents into another grid or sheet?
Hi, I have a grid or sheet where the rows which document status is already "SPC-approved" need to copy or populate to another sheet called "Approved Docs". Is there a way where this Approved-Docs sheet can automatically copy or get those rows with "SPC-approved"? Please lead me to an idea like formulas, automation…
