Each row of my data has 6 fields for each weekday of the week.
Name | Mon | Tue | Wed | Thu | Fri |
Person a | 9:00 AM | 8:30 AM | 9:00 AM | 9:00 AM | 8:30 AM |
Person b | 8:30 AM | 8:00 AM | 8:30 AM | 9:00 AM | 8:00 AM |
Let's say this represents the time someone should be coming in each day.
On each row (From another source) is the Weekday a report was run. So the data is now:
Name | Mon | Tue | Wed | Thu | Fri | Day |
Person a | 9:00 AM | 8:30 AM | 9:00 AM | 9:00 AM | 8:30 AM | Tue |
Person b | 8:30 AM | 8:00 AM | 8:30 AM | 9:00 AM | 8:00 AM | Tue |
Every "Day" value will be the same on the report for any given report.
I want to be able to retrieve the value of the field defined in "Day" so we'd add another column.....
Name | Mon | Tue | Wed | Thu | Fri | Day | Should be in at |
Person a | 9:00 AM | 8:30 AM | 9:00 AM | 9:00 AM | 8:30 AM | Tue | 8:30 AM |
Person b | 8:30 AM | 8:00 AM | 8:30 AM | 9:00 AM | 8:00 AM | Tue | 8:00 AM |
I could construct a monster "IF" statement in a formula tool, but that seems messy and excessive to me. Is there a better way to get the value of a field specified in another field?
Solved! Go to Solution.