If & Workday Formula

holli.nunn · 05/10/24

What is wrong with my formula? I want to calculate 3 workdays from the survey request date but only if the site plan test fit is checked…

Paul Newcome · 05/10/24

Move that very first closing parenthesis after the 1 to the end of the formula. You will also need to replace that first comma with an =.

Paul Newcome · 05/15/24

@holli.nunn Instead of "= 1" you would have "= "Yes"".

Paul Newcome · 05/10/24

Move that very first closing parenthesis after the 1 to the end of the formula. You will also need to replace that first comma with an =.

holli.nunn · 05/10/24

Thank you @Paul Newcome ! That challenged my reading comprehension and totally worked :)

holli.nunn · 05/14/24

@Paul Newcome - I had to switch this column for a colleague to a drop down list… how do I adjust this to pull over the 'yes'?

Paul Newcome · 05/15/24

@holli.nunn Instead of "= 1" you would have "= "Yes"".

Best Answers