Forum Discussion
LorraineChung
Qrew Trainee
Hi Alex, thank you for you very detailed reply.
I just have a few questions, especially about the FOURTH step.
How do I set up the formula fields? Do I need to somehow define [start tab completed] first before setting up the formula fields:
If([Start Tab Completed],
If([Part 1 Completed],
If([Part 2 Completed],
If([Part 3 Completed],
"Finish",
"Part 3"
),
"Part 2"
),
"Part 1"
),
"Start"
)
I just have a few questions, especially about the FOURTH step.
How do I set up the formula fields? Do I need to somehow define [start tab completed] first before setting up the formula fields:
If([Start Tab Completed],
If([Part 1 Completed],
If([Part 2 Completed],
If([Part 3 Completed],
"Finish",
"Part 3"
),
"Part 2"
),
"Part 1"
),
"Start"
)
AlexWilkinson
7 years agoQrew Assistant Captain
Exactly right. You would need, for example, a formula field called "Start Tab Completed" which might be something like this:
[Name]<>"" and [Address]<>"" and [Item]<>"
where those are three required fields on the Start tab.
[Name]<>"" and [Address]<>"" and [Item]<>"
where those are three required fields on the Start tab.