Forum Discussion
jcastr02
Post Prodigy
Post ProdigyIf formula based on another table
I have a master list of team members email address of whom need to complete a task. I have another table that is showing completion of a process with a task outcome column. I'd like to add a column...
Watsky
Solution Sage
Solution SageI would join the tables on e-mail address (as long as your master doesn't include duplicates) then created a calculated column
=IF ( Task [Task Outcome] = "Approved" , 1 , 0 )