Dajah’s Profile

Community member since September 2016

points
58

2

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

7

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. 

Situation:

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

4

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

5

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

2

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. 

 

Example: 

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

2

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. 

 

I