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)
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…
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…
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…
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…
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…
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…
Is there an easier way to disable all automatons at once if I have 41 rather than going through each one??
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?