The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.
I have the following tables within a base:ProjectsTimesheets, with each record linked to a single project and a single task type (single select field)Estimates, each linked to a single project and a single task type (single select field)I'd like to b...
I have been trying to develop a formula to output the amount of work hours between two date/time fields. This is for a base that has Time Off requests for employees.I have a field with a start date like this (9/16/2024 10:00am) and a field with an en...
Hello,My team uses a very well established and highly functional base as a Project Management and/or CRM tool. This base allows us to manage projects, client interactions, and project tasks. Unfortunately, we have hit the record, and we cannot determ...
Does anyone know why creating or linking records in elements with a linked record source is disabled (locked icon)? Right now, you see this when you mouse over those disabled buttons: This feature is not currently available in Interfaces for elements...
Not sure if this is an interface specific question, but it seems like the “hidden fields” order of fields settings have changed, at least in Interfaces.
It used to be that the hidden fields and field order was determined by the top most view in the t...
Hi @TheTimeSavingCo! Thank you so much for the quick response.I think I need to clarify. I'm in need of comparing estimated and actual time spent for each task type for each specific project. Would it be possible to do that?
Hi @Pascal_Gallais- ! Thank you for the quick response.For your questions, no time between 12pm and 1pm should be counted, so if the time off request lists 12:30pm as the start time, then the actual time off would be counted from 1pm. Likewise if the...
@Pascal_Gallais- Actually, this solution doesn't seem to work for the following casesWhere time off requests start and end on the same day but are only in the morning (less than 8 hours)Where requests starts or ends are not "on the hour" but less. We...
This works! Thank you so much! I modified the start date formula to be <=12 rather than just <12 so that time off requests that started around noon didn't count the lunch hour. (IF(HOUR({Start Date})<=12,16-(HOUR({Start Date})),17-(HOUR({Start Date})...
@Pascal_Gallais- thank you so much for the detailed and thoughtful response. I tried implementing it and I can't seem to get it to work correctly. Below is what I have, and please note that I did not exclude holidays yet in my formula, just for simpl...