About heron

你好,我有一个场景,created gap process to hire new resources, essentially adding new lines in our employee list. However one problem coming up is sometimes we created a gap and then an existing/internal team member applied and got the job. Not sure if there is a way we can somehow delete the original record based on the employee ID (that's the code for our employee list)? Since the newly created gap has some hiring data attached to it, we will like to keep the new line. In below example, essentially we need to delete line 1 first and then update line 2 current code with employee ID. Appreciate the help! Heron   ... View more

嗨,我有一个约会公式计算测试时ther the line item is falling within certain year, however cannot figure out what to do for the lines that fall outside of the model time period set up. For example, I have a contract that starts from 2020 to 2025 and the model is set up as 2 past year and 2 future year (so the model only captures up to 2022 currently). When I do the formula, because 2025 is outside my model time set up, it will always give false even though technically time now is less than 2025. Is there a way to get this right? Can anyone help? Thanks! ... View more