I have been searching for an automated way to get this done. I have a pretty intense (for me personally) form that my coworkers use to track a number of things that I measure. I am pretty married to m…
I am having problem to setup automation to alert someone. I have a column that shows 4 rows and another column that shows when the Alert someone should be sent out: Citrix/Network/PC Comm 1 - 3 weeks …
I manage a portfolio of projects which I have to report on. I'm a Pro user, so I don't have the functionality that could probably make this task very easy. My project managers are required to use a co…
Dear SS community, I'm exploring the use of Smartsheet for payroll whereby I import 3-4 different and formatted Excel files to SS. The challenge: the excel files are formatted (think merged columns, e…
Based on testing, automation is happening before cross reference calculation has completed. Rows are added through Dynamic View (DV). After a new row was added through DV, the calculated field (cross …
In an approval workflow when someone is notified on the Approved/Declined status, we have built a "message only" alert back to the user who submitted the request. The user will never be shared to the …
I have automation set up to work off a checkbox column. When I check the box, I want four separate emails to go out to four separate groups. Each group's email provides a distinct link specific to the…
I have been trying to create several automations that simply update a field based on the data in another field. Example is when Status = Complete, update % Complete to 100%. OR When status = Complete …
In my organization, we have ID numbers for tasks. They go something like this: Top Level: AB Second Level: ABcde Third Level: ABcde1 Fourth Level ABcde1.1 Where ABcde1.1 is the child of ABcde1 which i…
Hi everyone, I would need a formula where it picks the nearest date in the past related to today's date in another sheet. To give more context, the other sheet always shows Mondays as dates. I tried I…
