I have used a formula to create a new date value based on another date cell: The Next Due Date uses the following formula: SWITCH(Frequency,'Weekly', DATETIME_FORMAT(DATEADD({Task Due}, 1, 'week'), 'DD/MM/YYYY'),'Monthly', DATETIME_FORMAT(DATEADD({Ta...
Thank you so much for your help! I've been using AirTable for years and just starting to explore the scripting and formula aspects. I appreciate this community forum very much!!
