If then formula - word in one column = number in another column
Hi working on a work breakdown schedule and need if then qualifiers.
Idea is if the word "Design" is in the column "Who Produces the piece? (image below)
Automatically add "2" in the duration column in the row that has the copy "execute piece changes" under "task type" column.
Answers
-
If you are using the dependencies in the sheet, you will not be able to use a formula to populate the duration column.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thanks for the help Paul! Is there anyway I can make this work? Perhaps via automation?
-
You may be able to use the API or the premium add-on Bridge, but Automations cannot change dependency driven columns either.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 441 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 301 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!