So, I need to organize presence in my company meetings.
I created, in google sheets just to organize myself, a sheet where rows = users and columns = meetings and then each cell gained a color according to the status of that user in the meeting (green = present; light red = informed absent; and darker red = non-informed absent / disconsider black and blue)
My aim with this report is to have a global view of the presence of people in the meetings. I work with a lot of volunteer people, and I’ve noticed a pattern that when a person has 3 non-informed absents, they are probably going to leave the project…
And to do it manually is quite exhausting. So, since we are always putting this information in Fibery, I thought Fibery could automatically create something like that table.
You could also use a formula in the report to calculate a running count of uninformed absences (maybe even with a date condition of last three weeks or similar) you could have a chart that shows the users who are increasing in risk of dropping out.