We are managing a portfolio of projects that cut across multiple teams. Each team has a "spokesperson" that is responsible for completing a handful of reviews each month for portfolio governance, such…
Hi! New Smartsheet user here, appreciate any help and guidance. I'm looking to create a formula to build a custom auto-number function. I'm including a screenshot for reference. I'd like to automate t…
I am setting up an automation for my client and am having trouble sending out automated messages and wondered if someone could help me with a solution. Here's the structure: Sheet 1: Reports are submi…
Hi, I am trying to do the automation for replace latest row value from another sheet. So, I have a consolidation sheet and a reference sheet. Due do 2 of the projects submission are a week after the d…
I have a "Re-Release" process that is very long and complex. At one point in the process, a row goes through a series of automations that trigger each other. These automations copy the row to an archi…
I have a "Re-Release" process that is very long and complex. At one point in the process, a row goes through a series of automations that trigger each other. These automations copy the row to an archi…
I'm developing a skills competency checklist using 2 forms to collect info (1) self-assessment for staff to check-off skills and (2) Validation/Assessment from preceptor to check and sign-off that ski…
Hello Smartsheet Community, I've implemented an automation where changing the End Date field automatically sets the Status to "Completed" and updates % Complete to "100%." Here's the issue: When I upd…
