I want to write an if formula that will mark one column as delivered based on a tag in another column.
For example, i have one column for "substage" and another column for "stage". I'm trying to make the stage column change based on what is in the substage column. i believe that it would have to be a nested if function.
If the column in substage is tagged as "internal review" i want the stage column to say "post production"
If the substage column "client review" i want the stage column to say "post production"
Basically i just want the stage column to feed off the substage column with multiple different tags related to the stages.
Thanks for your help.