If then formula - word in one column = number in another column

Options
TullyONeill
TullyONeill ✭✭✭
edited 01/02/24 in Formulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!