JIM_AFO✭✭✭

@Paul Newcome this worked perfectly! Thank you for the quick reply and solution.

@Mike TV thanks for your reply. I've spent a significant amount of time with the Smartsheet team directly working on my issue and unfortunately there isn't an easy fix that can be achieved.

Thanks @Paul Newcome. I actually took a bit of a different approach and used a Helper sheet with the Index/Match formula to return the month end date. I've run into another issue though with returning the actual "Due Date" needed. I need the Due date to be 10 days after the Month End date. The "Days Post Month End" is…

@Paul Newcome I have a Month column which is a drop down selection consisting of every month. January-December. Is there a way to return in the Due date column a value based off the Month selected? Assume some sort of "IF" formula. For example - IF Month@row = "January" Then Due date column would return 1/31/23 or the last…

Hi @Genevieve P. - Thank you so much for putting this together. I had to make a couple edits but was able to get the results needed. Thank you again! -Jim

Hi @Genevieve P. I've just had some time to get around to trying this solution and refine my columns and data. Here is an update on my data structuring... My sheet has 2 "task" columns. Task Column #1 = primary task and is named [Task], to reduce the number of primary tasks we have offered an "other" task within task…

Hi Kelly- This worked perfectly. Thank you!