This used to be so helpful.
Now it is completely useless. It doesn't even open on Chrome. On safari it opens and then I'm not even able to select where I want to see the resulting formula (always get the error "the entered range is incorrect)
Thank you for your comment. Sorry to hear that you are having difficulties with our add-on.
Please note that there is currently an issue on the side of Google that occurs when you are logged in under more than one account. I kindly ask you to sign out and log back in only under the account you used to grant permissions to the add-on and try to reproduce the issue.
If this doesn't help, then please specify the version of Google Chrome you use and send us a short video or a few screenshots showing what happens when you open the add-on. As for Safari, please also specify the browser version and send us a video or screenshots illustrating the problem you have there. You can email all the details to firstname.lastname@example.org.
We will look into the issue and try to help.
NEED IMMEDIATE HELP
I have 2 columns of check boxes - Column A and Column B
In Column C are reference numbers
When Column A and B are true - I want Column D to indicate the reference number from Column C in list order AS BOTH A & B ARE TRUE. NOT ON THE SAME ROW. .
A2 AND B2 = C2 REF# CT99999X
A5 AND B5 = C5 REF# CT11111X
A10 AND B10 = C10 REF# CT55555X
A10 and B10 are true before A2 and B2 and A5 and B5. Then A5 and B5 becomes true next, then A2 and B2 becomes true next - THEREFORE IN COLUMN D SHOULD LIST THE REFERENCE NUMBRS IN ORDER AS BOTH A AND B MATCH ARE TRUE
1) A2=CT55555X (READY FIRST)
2) A3=CT11111X (READY SECOND)
3) A4=CT99999X (READY THIRD)
Thank you for the detailed description. For us to be able to help you better, please share your sample spreadsheet with us at email@example.com. To grant us access to your data, press the Share button at the upper right corner of Google Sheets and enter firstname.lastname@example.org.
Note. We keep that Google account for file sharing only and don't monitor its Inbox. Please do not email there. Once you share the file, just confirm by replying to this email.
If you have confidential information there, you can replace it with some irrelevant data, just keep the format. We will do our best to help.
How do you "reset" the IF Formula Builder to start fresh?
If you need to delete a sketch of some function you've entered into the add-on's window, then you can use the Undo button at the bottom of the pane or simply restart the tool. In case the 180-day trial has expired, I'm afraid the only option is to buy a subscription. Thank you.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!