The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Is there a way to count the number of weekdays between a date range? I am currently using the following formula to count the number of days between the FROM and TO DATE:DATETIME_DIFF({To Date}, {From Date}, 'days')+1 If the date range includes a week...
This is basically a leave tracker. Table 1: Employee DetailsThis table contains the start date of the employee and a column that computes the available leave credits they have accumulated.Column LEAVES is linked to Table 2 and should look up the dura...
I'm trying to compare data from 2 columns to result in a rating. I'm trying to break it down first before going crazy with multiple IF AND statements. Below is the first working example:IF(AND(A=100, B=100), 5, BLANK())Below are the conditionsIF A=10...
@Marielle_Gueis1 I had a hard time figuring this out. Reversing the steps is easier said than done. I need more practice but your recommendation did make more sense after rereading it a million times! lolAgain, thank you!
@Marielle_Gueis1 , thank you for taking the time to answer my query.I was able to make this work by following your suggestion. However, I am not sure how to do the last part to not overwrite existing records. Currently, It is getting overwritten. I'v...