Hi all ,
I would like to know , when I set a an alert so that an action must be triggered when reaching a certain date , at what time the action is actually triggered ? 00:01 ?
Thanks in advance .
If I understand you correctly, it will run at the time that you select from the list when you set up the Automation.
Have a fantastic weekend!
Workflow Consultant @ Get Done Consulting
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.
Hi ANDREE ,
Look at this formula : " IF([Due Date]1 = TODAY() + 3; 1; 0) " .
The formula is inside a check box cell ( column ) . As you can see , there is no time .
So my question is : " If the condition is met , at what time the cell concerned will turn checked ? " .
I hope it's clearer to you now .
It depends on what you've set the setting, Run workflow to. If it's when triggered, it will send almost immediately.
Because you are using the TODAY() function, you will need to activate the sheet either by opening it or having a new form entry for the TODAY() function to update to today's date. As soon as the sheet is opened, the TODAY function will update and the box will change to checked.
It will register to run your workflow as soon as it is saved after the box has become checked. I can't remember the exact times, but I believe it usually takes no more than 15 minutes for the alert to be sent. I personally usually get it much faster than that, but I believe that's the amount of time Smartsheet has referenced in documentation.
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
Are you telling me that I have to define some settings ? How ?
Hi PAUL ,
Thank you .
Happy to help!
Happy to help!
I see now that I've misinterpreted your questions.
You want to know at what time the checkbox would get checked right?
I too misinterpreted. To answer the question of "What time will the box be checked?"...
Because you are using the TODAY() function, you will need to activate the sheet either by opening it or having a new form entry for the TODAY() function to update to today's date. As soon as the sheet is opened, the TODAY function will update and the box will change to checked. Once the sheet is saved, the system will recognize the box as checked and run any workflows accordingly.
The number of Unlicensed Users was listed previously under User Accounts. Why is it no longer there?
I have a filter set so that if this task complete box is checked, then the row is hidden. Is there a way to make it so that if the parent row is checked, then the child rows hide as well? Right now when a parent row is checked, only the parent row is hidden.
Does anyone know why Editor cannot insert columns in a sheet? What's the harm in that? I can see why you might not want someone to delete or rename a column, but inserting a column seems harmless.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.