Is there a workaround for these automations if I have this formula in my Smartsheet?
Answers
-
@Paul NewcomePredecessor formula I'm guessing
-
Essentially these automations aren't activating. I was reading up on how to do these automations but saw that I needed to avoid cross-sheet formulas and linked cells. So my thought was that the Predecessor column was the reason for the automation not occurring.
-
-
Currently the status column is changed manually
-
Can you provide screenshots of the actual automations? So far there is nothing that I can see that would be preventing the automations to run.
-
Here is the sheet I want to move to. Mimicked the column names to avoid confusion in the integration
-
@Paul Newcome I believe what @vntjxnes is asking about (correct me if i am wrong or misunderstood), your wanting the AUTOMATION to clear the cells value under the Predecessors Column and currently its not doing so right?
if yes, there were a few requests like this in the past and not sure if those have changed or not, but might provide additional clarification/tricks/workarounds or the worst answer of being "No". Hope this helpsIs there a way to remove Predecessors from a row via the API in c#? — Smartsheet Community
Julie Becker ☠️
Construction Project Engineer / Coordinator & Software Program Oversight Mgr. 😉
Successful People Are Not Gifted; They Just Work Hard, Then Succeed On Purpose‼️
-
@Julie Becker It is also the Move Row automation that isn't firing.
-
@Julie Becker thanks for the suggestions. I read the thread and will look into trying to understand the API coding to solve the issue of removing the predecessors. @Paul Newcome is correct. The Move Row automation also is initiating.
I created 2 test SS to see if these automations would work. The Predecessor automation populates "#REF" in the Predecessor column of the successor line of the row that was moved. The row was moved to the other SS so that's a plus.
-
Some how the automations are now working! Thanks for your support!
