Check out theFormula Handbook templateto view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.
Sign in andask it here!The community's got your back.
Wondering if there’s a problem?
Check out theStatus Pageand subscribe for notifications.
Share your knowledge!
Help others byanswering questions.
Formulas and Functions
Discussion List
Help Article Resources
Categories
Popular Tags
- Formulas10,877
- Project Management4,398
- Sheets3,766
- Reports2,638
- 形式2,433
- functionality2,174
- Automations1,930
- IT & Operations1,754
- Enhancement Request1,572
- Support1,551
- Cell linking1,548
- Email Notifications1,460
- Account and User Management1,398
- Dashboards1,266
- Integrations1,243
- Conditional Formatting1,216
- Construction1,092
- API and Developers927
- Sharing and Collaboration904
- Workflows in Smartsheet871
- Manufacturing864
- Update Requests836
- Gantt View797
- Product Development794
- Attachments788
@dbarrett013<\/a> I think the workflow stops once the first leg\/first project is executed because there's no trigger asking it to check the rest of your conditions. I guess you should try separating these and see if that resolves it.<\/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":[{"tagID":218,"urlcode":"construction","name":"Construction"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}]},{"discussionID":110806,"type":"question","name":"I need to change a column named Event Type to a \"V\" or \"I\" based on the value of another column.","excerpt":"I need to change the Event Type column to a \"V\" or \"I\" if a column named Event location contain the word \"Virtual\" or \"virtual\". I have tried several versions of IF statements but they all give errors. Below is the last version I tried. =IF([Event Location]@row, \"Virtual\", \"V\", IF([Event Location]@row, \"virtual\"), \"V\",…","snippet":"I need to change the Event Type column to a \"V\" or \"I\" if a column named Event location contain the word \"Virtual\" or \"virtual\". I have tried several versions of IF statements but…","categoryID":322,"dateInserted":"2023-09-26T18:15:29+00:00","dateUpdated":null,"dateLastComment":"2023-09-26T19:12:40+00:00","insertUserID":154002,"insertUser":{"userID":154002,"name":"SmartSheet Newbie","url":"https:\/\/community.smartsheet.com\/profile\/SmartSheet%20Newbie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/OLZT5TMCDLUA\/nLGJGXEA8PX07.png","dateLastActive":"2023-09-26T19:12:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":159703,"lastUser":{"userID":159703,"name":"Monique_Odom_Comcast","title":"Process Manager","url":"https:\/\/community.smartsheet.com\/profile\/Monique_Odom_Comcast","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zUkrM9vny0o!ZQkomVvUbwo!vBgDVSQJmmG","dateLastActive":"2023-09-26T19:05:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3391508889,"url":"https:\/\/community.smartsheet.com\/discussion\/110806\/i-need-to-change-a-column-named-event-type-to-a-v-or-i-based-on-the-value-of-another-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110806\/i-need-to-change-a-column-named-event-type-to-a-v-or-i-based-on-the-value-of-another-column","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":110806,"commentID":397060,"name":"Re: I need to change a column named Event Type to a \"V\" or \"I\" based on the value of another column.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397060#Comment_397060","dateInserted":"2023-09-26T19:12:40+00:00","insertUserID":159703,"insertUser":{"userID":159703,"name":"Monique_Odom_Comcast","title":"Process Manager","url":"https:\/\/community.smartsheet.com\/profile\/Monique_Odom_Comcast","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zUkrM9vny0o!ZQkomVvUbwo!vBgDVSQJmmG","dateLastActive":"2023-09-26T19:05:43+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-26T19:16:50+00:00","dateAnswered":"2023-09-26T19:10:41+00:00","acceptedAnswers":[{"commentID":397059,"body":"
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/8JUALL7DUEU5\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
