Dajah’s Profile

Community member since September 2016



I have a source sheet with hundreds of rows of entries. One of the columns is named Property. There are many different values under this column. I have a destination sheet for each one of these possible values (in this case, a property). 

What I would like is to have have any rows in the source


I understand I can likely do this with a very, very long VLOOKUP  or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy. 


I would like to have a form where someone selects one option from a dropdown of ~100 items. That value then populates


I'm using the ticket template and want to use the update request feature. Currently it seems like the only way to do an update request is to assign it to a specific user, which doesn't make sense if you have an entire department working on tickets at different times of day. 

How do you request an


We're using a ticketing system and trying to find a way to trigger automatic update requests when a ticket/row has been unacknowledged for more than 12 hours. Currently we're using the comments feature to post updates to the ticket across shift changes. 

How can I set an alert to go out if there has


I'd like to select an item from the dropdown menu in my primary column, and have the two following columns fill with predetermined information. 



We have 100 items. When I select one from the dropdown menu in column 1, the following two columns automatically fill in the prices associated


I've got a column (called "Dates") formatted as dates. I would like the adjacent column to show the day of the week that date falls on. Using the formula =text((Date1), "dddd") brings back an #unparseable error in the cell. I've tried using brackets instead of parenthesis but it hasn't worked.