This content has been marked as final. Show 3 replies
1 of 1 people found this helpful
Can you please try using a formula like this:
case projecttype when 'Common Tools' then 'NA' else 'Project Preface' end
This should be the last column on your sheet!
Hope it helps!
Can you please share a workbook?