-
Any way to update formula criteria with drag-fill
Hello, I have a sheet with around 3000 rows all of which have a date received and I am trying to count how many were received per week. Currently I have a helper column which has the week number (1-52) and have =COUNTIF([Week number]@Row, =1) which works but I am wondering how to then extend the formula to automatically…
-
Automation to record values from one smartsheet onto a new row on another smartsheet once a week?
Hello, I imagine the answer(s) to this question already exist but I haven't had luck finding them, please point me in the right direction, here's my situation: I have a Smartsheet ("sheet 1") that my team records numbers on during the week every week. "Sheet 1" has 100 rows, and there's one column ("column x") in "sheet 1"…
-
If I lock columns down so that users cannot edit them, can I still use the "Copy Row" automation
-
SmartSheet Automation - Notify Emails not triggering at all
Hi all, I've ran into an issue where on all of my sheets I have that's shared out to dozens of users and are on the distribution list to receive emails based on rows added/changed with criterias to trigger email sendouts to them. This has been working fine the past 2 years. However, as of 2 days ago all emails have stopped…
-
Multiple Conditional Pathways to One Action
Hello, I am trying to create a weekly digest to send out once a week with multiple criteria using automations/ workflows. I am running into a problem because I am having to create multiple pathways due to differing logic which is forcing me to enter different actions for each pathway. Although I know I could recreate the…
-
Automated email to Contact in a Cell
Hello, Is there a workaround to send an automated email (box check) to a contact in a cell, but its not a contact column, rather than a formula column? many thanks!
-
Move rows automation is transferring the entire sheet, not just the rows that are "checked"
I set up the automation shown below to transfer a row to another sheet once a check mark is selected for said row. However, when the automation runs, it transfers the entire sheet to the "Past Eval Results" sheet, including the rows that are checked and not checked. Is there something I am missing in the workflow?
-
Action : change cell value
Hi Community, I feel like this is simple question, but I can make it happen. If I want to using change cell value in automation workflows, can I change the cell value by using formula? Cause I use the formula to change, the result always add ' in front of the formula…(show as the pic below) Besides, can it make the value…
-
Is there a way to generate an alert/block on Smartsheet, in case a schedule causes overallocation?
Hello everyone, On Smartsheet, I have a workspace containing a series of sheets (one for each active project) where various resources are planned. Both on Smartsheet and Resource Management, each resource has 8 hours/day available (i.e., 1 day = 8 hours). If I schedule a resource on two different sheets, assigning it to…
-
Automated project ID using 2 column variables
Hi! I'm trying to create a formula or automate the generation of a project ID but it needs to include 2 separate variables where the information are in 2 separate columns. Column 1: Has 1 of 5 pillars with the pillar number and text. Below Build a community to enable the academic mission Create a thriving, fair and diverse…