Trending in Formulas and Functions
-
Inventory Formula Question
I am trying to keep track of items we have to give out to community members. Mostly I am just making sure I know when I'm getting low on a certain item. I made two sheets, one with the name of each unique item and one with more details that allows me to keep track of the person and date the item was given. Those details…
-
Find the latest time entry and send a reminder if theres no entries in the future
Hi. I have built a form for our HR department to log their whereabouts for the following week. The team also receive an automated reminder every Wednesday to submit 5 entries (one row = 1 day) for each day of the following week. They simply advance the date field and select their whereabouts for each day. Although this is…
-
Is a blank date cell "not in the future"?
Working with automation, conditions, where date field is set to "is not in the future". How does that work with a blank field? Is a blank date field considered "is not in the future"? Or do I need to add an "or" date field "is blank" to this? (same goes for "is not in the past".