Having a hard time as a new user to Monday.com where I have column A that will show a simple yes or no field. Column B will have when the submission date was entered into monday.com. I want to create a if statement that says if column a is Yes, then add 5 days to the submission date and place the new date in column C, if no, add 8 days to the submission and place that date in column C. So far, and it doesn’t work I have the following logic:
IF({Column A} = “Yes”, FORMAT_DATE(ADD_DAYS({Submission Date}, 5)),
(IF({Column B} = “No”, FORMAT_DATE(ADD_DAYS({Submission Date},8)),
Thanks for your assistance!