Blog

I can go to https://slack.com/admin/atlas/configure-profile and create a Number field for member profiles. That’s easy enough. The problem, they can arbitrarily edit this field. I would like to assign members a number, which they cannot change. Is this possible?Read more

I made an account on YouTube 10 years ago with a yahoo email id. How do I login to this account in today’s date? I can only see a Google account login which obviously gives an error if you enter Yahoo s email IdRead more

My filter function is almost there, but not quite. I want to display only those rows in List1 one that are not in List2, based on the email column (c). This works without the NOT and it displays only the matches, so of course I need to add a NOT to display only those thatRead more

In my Google analytics dashboard, I’m seeing 14T instead of 14K. Even though I’m not bothered by this, I’m just curious why this change is. It same case for the google play store as well. My question is why Google is using T instead of K? I’m pretty sure my page views are not inRead more

I am able to get todays high / low / open with below formula correctly. =INDEX(GOOGLEFINANCE("NSE:CIPLA", "HIGH")) but not able to get todays close with below formula. =INDEX(GOOGLEFINANCE("NSE:CIPLA", "CLOSE")) it gives below error -> "Function GOOGLEFINANCE parameter 2 value is invalid for the symbol specified" the question which is answered here > How to getRead more

How can I get a list of Sheet2!A2:A cell values where (Sheet2!B2:B= "Yes") and (Sheet1!B2:B less than 200) (ignoring values that are in Sheet1!A2:A but not in Sheet2!A2:A) https://docs.google.com/spreadsheets/d/1TPXl4qnUcufrbBZ-mEoz6LPEiL_XtXw374r0IDITudg/edit?usp=sharingRead more

I couldn’t find the option. I looked at: https://www.concursolutions.com/Expense/Client/default.asp: https://www.concursolutions.com/Expense/Client/default.asp -> expense report -> click on one expense I couldn’t find any info on Google. https://sapconcur.psu.edu/faq/how-do-i-delete-attached-receipts only deals with receipts that are attached to a report.Read more

I currently have a Google spreadsheet that keeps track of all orders and the progress: Column 1: Order Form Sent Column 2: Order Form Received Column 3: Delivered to Pick Up Site Column 4: Picked Up For those columns, I have entered checkboxes with data values of "true" or "false." On my sheet, there areRead more

I just changed my password & google verified that but why would a different city than mine show up?Read more

I could be getting a call in Facebook Messenger (heard the beeping), and accept the call on the computer, and start talking, only that now the iPad in the study room, and the iPhone in my jacket or pants keep on beeping NON-STOP. I was at first going to just keep on talking and hopeRead more