When I change my Status column to Cancelled the specified cells do not clear. So what have I done wrong?
There can be a slight delay, and sometimes it needs a refresh.
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
I hope you're well and safe!
First, ensure that you have allowed yourself to receive notifications properly in your Personal Settings (circle/profile in the lower-left corner). Secondly, check the Permission setting for the Automations. (cog in the top right corner in the Automation overview)
Ensure that you've checked the Sheet Change Notification Settings box to Include my changes in sheet notifications in your Personal Settings (circle/profile in the lower-left corner).
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Thank you Andree for those tips. I set Permission setting for the Automations to Unrestricted and have all notifications for Personal checked. This didn't affect my automation script. When I set a row's Status to Cancelled, it does not blank any of the cells like it should. The Conditional Formatting I have setup does change the row color to orange but the automation script does not work.
Happy to help!
I'd be happy to take a quick look.
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])
Share invitation sent.
In your Workflow, you have a condition looking, so it's Cancelled, which is probably why it's not working. Try to remove the Condition.
Did that work?
I removed the Condition but there was no change when I set a row Status to Cancelled. No cells were cleared.
Hold on a minute. When I went back to my sheet from here, the cells were cleared. There seems to be a delay in them clearing.
Yes, the automation script is clearing the cells now (since removing the Condition) but it takes several minutes to see the changes. Seems odd to me there is such a delay when Conditional Formatting is immediate.
Yes, the Refresh updates it immediately.
Thank you for the help.
You're more than welcome!
Hello - is it possible to use a group already established in SmartSheet to fill/populate a drop list for a data point? Example - we have a SS group created for 40 project managers, I would like to type the name of the group in the drop down and the 40 names populate in the drop down list without having to type all 40 names…
Hi, Is there a way to notify users on a specific month rather than every month? Thanks!
Hello Smarties! I need your help and ideas. I am trying to do some automations if a specific row is not checked after a specific date. I don't want it to interrogate the entire column, even if I need to create a new column, is there a way to do this?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.