If & Workday Formula

holli.nunn ✭✭✭

05/10/24 in Formulas and Functions

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…

Tags:

• Formulas
• help

0 · Share on FacebookShare on Twitter

Sign in

Try for free

Best Answers

• 

  Paul Newcome Community Champion

  05/10/24 edited 05/10/24 Answer ✓

  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 =.

  CERTIFIED SMARTSHEET PLATINUM PARTNER

  10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)

  Would you benefit from getting my help in person?

  0 · Share on FacebookShare on Twitter
• 

  Paul Newcome Community Champion

  05/15/24 Answer ✓

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

  CERTIFIED SMARTSHEET PLATINUM PARTNER

  10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)

  Would you benefit from getting my help in person?

  0 · Share on FacebookShare on Twitter

Answers

• 

  Paul Newcome Community Champion

  05/10/24 edited 05/10/24 Answer ✓

  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 =.

  CERTIFIED SMARTSHEET PLATINUM PARTNER

  10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)

  Would you benefit from getting my help in person?

  0 · Share on FacebookShare on Twitter
• 

  holli.nunn ✭✭✭

  05/10/24

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

  0 · Share on FacebookShare on Twitter
• 

  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'?

  

  0 · Share on FacebookShare on Twitter
• 

  Paul Newcome Community Champion

  05/15/24 Answer ✓

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

  CERTIFIED SMARTSHEET PLATINUM PARTNER

  10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)

  Would you benefit from getting my help in person?

  0 · Share on FacebookShare on Twitter

Sign in

Try for free

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list