Michael Kingsbury’s Profile

Community member since November 2018



We have 3 licensed users. One of the users left the company and is no more accessible. We would like to move his license to another user, and move the ownership of all his sheets to another user too.

I am one of the licensed users. What should I do first? move his license then move the ownership of



I am new to using formulas and am struggling with trying to automatically check a checkbox in one column if, in the Risk column, the RYG risk is red or yellow, not checked if risk is Green. I am able to get the following formula to work for red and yellow:

=IF(OR(Risk1 = "Red", Risk1 =