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…
Hello, I've pretty new with Smartsheets and most of the time I try to use the examples from other posts that I have seen others put up in order to solve most of the problems that I have. Unfortunately…
Hey all, I set up an automation to request an update if one field is blank and if another field is not a specific list of departments and I got an email this from someone in that department saying the…
Hi All, I used the following formula to retrieve ancestor (first parent) date value of the multi-level parent-child rows for each row. =LEFT(INDEX(JOIN(ANCESTORS(Date@row), ","), 1), 8) The issue that…
I would prefer for it to send a notification until the conditions are met starting on a Wednesday at 9AM and only stop once a date that falls within that week in the Update Date field is applied. Is i…
While I was at Engage 2023, I attended the Advanced Automations session where it looked like I'd be able to setup an automation that would pull from an "email address" column to send out automated ema…
Hi there I'm baffled - this sounds like a standard process but I can't work out how to do it and would appreciate any advice. I have a database, the first item in column one is "UPDATE DATE". I want t…
Hi, Does anyone know why we can't use automations to change the cell value in symbol columns, like the RYG balls? It doesn't make sense to me that it's available for dropdowns but not for these. I do …
