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

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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!