Formula within a formula

Laurie
Laurie ✭✭
edited 10/15/20 in Formulas and Functions

Good afternoon everyone,

I was wondering if it is possible to do an IF formula with a date formula in the same cell?

I would like to do the following, but also subtract the number of working days between two dates.

IF(Status@row "Complete", 0, .....


Below is the formula I have now.


image.png


Tags:
· Share on FacebookShare on Twitter

Answers

  • Thinh Huynh
    Thinh Huynh ✭✭

    HI @LaurieΒ ,

    I was wondering if it is possible to do an IF formula with a date formula in the same cell?

    Yes, of course you can can. Try this formular:

    =IF(Status@row="Complete"; 0; [End Date]@row - [Start Date]@row)


    Hope it helps!

    · Share on FacebookShare on Twitter
  • Laurie
    Laurie ✭✭
    edited 10/20/20

    Hi Thinh,


    I tried this but it came back with UNPARSEABLE. Do you have any other suggestions?


    Actually, I went back in and saw you put semi-colons, so I replaced those with commas and it worked great! Thank you!

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!