Looking for a simple formula that spits out that last Friday of the calendar year. I'm trying to avoid needing to make this a manual update so would love to find a formula that just spits that out without me having to update it at the beginning of th...
TLDR: I'm trying to mark employees as "OOO" if they are OOO for 3 or more days of the week (vs if they are only OOO for 1-2 days of the week they still show up as available). I have a system set up where I have created an "open space" record for ever...
Thank you for considering to help me! Here's the process I'm trying to create:A new record is created via a form which will have a start and end date (i.e. 7/3-7/28)Based on the timeframe (above), I would like to set up an automation where additional...
I'm having a hard time finding a simple script that will allow you to duplicate a record via automation.My end goal:Trigger: When a record matches a condition (i.e. a checkbox is checked off)Action: Run script --> this is where I can't find a script ...
Used Case Scenario:Table Set Up:I have a Requests Table, a Designers Table and the North America Availability Table.Requests come into the Requests Table but based on the requested roles, there are automations set to create a linked record in the NA ...
Amazing! Thank you @Sho and @David_Skinner ! If I wanted to change the output to a MM/DD/YYYY format, what's the best way to do that?Really appreciate both of your quick responses!
Hi @Russell_Bishop1 ! Thanks for responding. My tables are a bit complex so I'll do my best to explain.I have 2 main tables that are involved in this scenario:Table 1: Employee TableTable 2: Resourcing TableIn the resourcing table, this is where I ha...
Wow, @Kamille_Parks !! I'm honored that you used my question on your podcast, THANK YOU! this solution is brilliant - exactly what I was looking for. I'll work on testing it and will let you know if I have nay questions. THANK YOU SO MUCH!
