egordin - profile

egordin · Sep 04, 2024

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...

egordin · Aug 16, 2024

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...

egordin · Apr 20, 2023

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...

egordin · Mar 29, 2023

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...

egordin · Aug 05, 2022

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...

egordin · Sep 04, 2024

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?

egordin · Aug 28, 2024

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...

egordin · Aug 27, 2024

@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...

egordin · Aug 25, 2024

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})...

egordin · Aug 23, 2024

@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...

User Statistics

User Activity

Comparing Records

Time Off Hours Request Duration Formula

Optimizing Existing Base due to Record Limit

Creating records in elements with a linked record source is disabled?

Hidden Fields & Field Order in Expanded Records

Re: Comparing Records

Re: Time Off Hours Request Duration Formula

Re: Time Off Hours Request Duration Formula

Re: Time Off Hours Request Duration Formula

Re: Time Off Hours Request Duration Formula