Hi, Does anyone know when changes happen how long it takes to receive an approval request email? It passed more than five hours but still not received the approval request email. Checked my spam box n…
I have an automatically generated date column in my sheet 'Created Date'. I want to be able to override this date with a manually entered date 'Manual Date'. I created a new column called 'Inquiry Dat…
Hello, I am looking to be able to auto-populate the pending permits based on the empty date cells where we input our received dates. I currently have to manually choose what permits are missing, but a…
The formula I am looking for is if a PO Amount is greater than 50,000 then return a circle but if it is greater than 100,000 return a square and if it is less than 50,000 return a triangle. I have tri…
I know I can view who marked a check box through view cell history but I'm looking for a way to display the person who marked an "approved" or "Done" check box without all the extra clicks; I need a v…
I need to schedule work on a particular route. Within my records I have a column named "Route" that shows the route number. EX: 10402. I have a DATE column called "Target". I want to add a column call…
What function can pull this math but only for cells which have the date in it? I'm just trying not to see an invalid alert on everything - only some projects will have data in the cell referenced for …