Trending in Formulas and Functions
-
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".
-
Percent Complete of Status Column
I am looking to have the Parent row show the sum of percent complete for children in the status column. Based on the photo attached, the formula I am using is not calculating the "Activity 1" cells being marked complete. I am using the formula: =COUNTIFS(CHILDREN([Status]@row), "Complete") / COUNT(CHILDREN([Status]@row))