SHEET A: Trigger: When rows are added or changed AND when "assigned to" changes to any value Action: copy a row SHEET B EXAMPLE/ISSUE: Sheet A Row 1 is "assigned to" Joe This row is then copied to the…
Hi all, I'm hoping that you can help me find an easy solution to an issue I'm facing. I publish two monthly newsletters (External and Internal editions in the screenshot below) and the first step of m…
Hi, Any suggestions to increase speed of "Immediate" in Datamesh? Today, immediate seems to be at least 4 minutes. What can I do to speed this up? Datamesh source and target are the same sheet. (Pick …
Hello! everyone I was wondering if someone could help me with a formula We have an audit schedule based on 5 years and I currently have the "Count" essentially telling me how many times a topic was au…
I have a task list, and I want to use automation to supply the date the checkbox gets checked. Here is my workflow: Am I misunderstanding this workflow? Do I need another condition in there somewhere?…
Hi All, We are using Control Center for our projects, we use it with 4 different countries and every country has it own set of templates that they can select when creating a project. So in total we ha…
Hi, I primary columns with customer ID's. I have date columns I put today's day in when I have contacted that client. What I need is, when I put a date in the date in the column, is to have all the cu…
Hi all, I am using the smart sheet api to read and update a rows values. I am performing this task using a python script and then requests library. My current code setup looks something like this ----…
Hi - I was asked to set up this dashboard: The template has been downloaded and the new workspace has been created. The form is set up, and when I did a test fill out of the form, the data went to the…
In this scenario, Index Smartsheet automation is to happen based on data in the Licensing Smartsheet. More specifically - Check box in Ready To Start E. cell in Index Smartsheet when Licensing Smartsh…