I have a series of records that include a Start Date field that I want to incorporate into a larger CONCATENATE formula. However, some of the records do not yet have a date and the Start Date field is blank so my formula is returning an #ERROR. I ...
Hello!I have a list of records that all have a start date and end date column for a number of employees. I am wondering if there is a way to calculate the number of employees on a given day. All the employees have different start and end dates. So...
Hello
I have a long list of records that I have grouped by 2 fields (first by Week # single select and then by Start Day and Date Formula). I then want to sort so that all the records are in chronological order (sorted by Week #, then Start Day and ...
I am having trouble sorting a list of records in chronological order by date using a field that I have formatted with a formula that calculates the day of the week, month, day of month. The sort is defaulting to alphabetical.
The formula I’m using i...
I’ve not had luck with sorting from a hidden field. Is this due to the fact that I have the records grouped. It seems that I am not allowed to sort by a field that is not a part of the grouping.
Further explanation:
I am grouping by “week #” field ...
