![]() ![]() I set a function stating =IF(DAVES TODO!A6=TRUE) and the boxes "true" value now takes shape with this command, and checks itself if my employees personal to do list also has a check on his tab.įurthermore, another problem I ended up solving was importing a range from a different spreadsheet but wanting the checkboxes to remain. Simply check (or uncheck, if you set true values first) to apply a rule for the opposite value as well.įor instance, I have a master to do list that coincides with employees' personal to do list. if you erase the TRUE or FALSE in the text bar, and replace with a formula, the checkbox inserted with the easy tool will now take role to your formula. If you click on the cell itself, not the box directly to check or uncheck, you will see int he text bar it holds TRUE or FALSE. ![]() Maybe google has since changed their capabilities with this, but I am able to do this with ease. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |