How can I trigger an IF statement only once?
I have a column that is a single select drop down menu. We use this to keep track of who is responsible for that line as the project moves through our departments. A couple of the selections are outside our company. We want to record in a separate column who the outside contractor is. I am attempting to copy the name of the outside contractor from the responsibility column to the outside contractor column the first time it is selected. Once it is copied into the outside contractor column I don't want to overwrite it again. I attempted to use IF statements and Automations, but I am unable to get it to work. Any help would be appreciated. Thanks.
Answers
-
Andrée Starå ✭✭✭✭✭✭Hi@Bobert
I hope you're well and safe!
How many Outside Contractors could you have?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
✅我的帖子(s) help or answer your question or solve your problem? Please support the Community bymarking 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.
-
Bobert ✭✭The drop down has about 15 selections. 3 of those are outside contractors. We're trying to keep track of which outside contractor is working on the project, so that even when the work comes back, we know which one we sent it to.
-
Andrée Starå ✭✭✭✭✭✭
I'd recommend using a Workflow combined with the Assign People Action or similar.
Would that work/help?
✅Remember!我的帖子(s) help or answer your question or solve your problem? Please support the Community bymarking 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.
Help Article Resources
Categories
![\"example.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/LCYBMPOFK1T6\/example.png\")
<\/img><\/a>\n <\/div>\n<\/div>\nOnce you remove that, you should be set!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":110956,"type":"question","name":"Formula IFS return values from other columns","excerpt":"Hi, i am trying to set a new column that should return EAS or ETS text depending of what it is in column named \"ETS\", but i want to add another if that return a value from column \"Business Dropdown\" if the column ETS is blank. This is the formula that i wrote now very simple and it is running well, but it is missing the…","snippet":"Hi, i am trying to set a new column that should return EAS or ETS text depending of what it is in column named \"ETS\", but i want to add another if that return a value from column…","categoryID":322,"dateInserted":"2023-09-28T20:10:28+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T20:35:00+00:00","insertUserID":140104,"insertUser":{"userID":140104,"name":"Raul Cabrera","url":"https:\/\/community.smartsheet.com\/profile\/Raul%20Cabrera","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!WxHVX93-X34!CelZAvGm7jw!7qwcGhKSeo9","dateLastActive":"2023-09-28T20:50:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":165153,"lastUser":{"userID":165153,"name":"DKazatsky2","url":"https:\/\/community.smartsheet.com\/profile\/DKazatsky2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T20:51:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":20,"score":null,"hot":3391865728,"url":"https:\/\/community.smartsheet.com\/discussion\/110956\/formula-ifs-return-values-from-other-columns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110956\/formula-ifs-return-values-from-other-columns","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":110956,"commentID":397531,"name":"Re: Formula IFS return values from other columns","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397531#Comment_397531","dateInserted":"2023-09-28T20:35:00+00:00","insertUserID":165153,"insertUser":{"userID":165153,"name":"DKazatsky2","url":"https:\/\/community.smartsheet.com\/profile\/DKazatsky2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T20:51:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/ASKPITW4DU25\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-28T20:50:48+00:00","dateAnswered":"2023-09-28T20:35:00+00:00","acceptedAnswers":[{"commentID":397531,"body":"
