Community

1

Good morning,

 

I'm loving this feature in Outlook! It's always there, so if a new assignment is sent I can simply add it to SS from the email. Sweet!

 

In clicking on a sheet name for an existing entry I notice it only goes to the sheet and not the row. Is this on the future enhancements list, by

3

Technical Part:

 

I had in cell "[Q1 - Points]2" =IF([1.- Question]2 = "c) Right Answer", "10", "0") and in cell "" I had [Q2 - Points]2=IF([2.- Question]3 = "e) Right Answer", "9", "2") and both formulas work right by themselves. Nonetheless, as I wrote down =AVG([Q1 - Points]2:[Q2 - Points]2) in a