Autofill cells when new line is created
Hello,
I'm trying to figure out if, when a new line is getting filled out on my SS, can a workflow be created that will autofill a certain cell within that row to a particular choice within that dropdown list? In other words, someone enters a new row and starts filling out the required info. As soon as that info is starting to be filled out, I'd like that "Status" cell to show "Pending" right away. As certain things get filled out, we can change the "Status" to other choices in the drop down.
Thanks
Answers
-
Greetings @Walt L,
The short answer to your question is yes.
To start, the initial trigger should be set to When rows are added; if you want this to occur when rows are changed, select When rows are added or changed.
Now you can add your conditions based on the criteria you want. If you want more conditional paths, select add condition path using the blue +.
For example, Where the Column name is one of the criteria and the action you want.
You can add additional conditions with and/or.
I hope this helps and gets you started in the right direction.
Frank Smith, PMP
Assistant Director | IT Special Projects Mgr.
Oregon Parks & Recreation Department
If my response helps, please mark it as an accepted answer. 😎
-
Thank you for responding. Shortly after posting, I realized that I pretty much had this set up p/ your notes, but bc there was already data in the rows previously, the autofill was not working. So, I scrolled down many lines and entered some data and the autofill worked.
Much appreciated.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!