Help with IF / Then, or something like it

11/28/18 Edited 12/09/19

Hi Everyone, New to smartsheet and need some help.  I'm trying to calculate a date in the future, only when the manager approval column is Approved.  I've figured out the date formula, thanks to another discussion, but I'm unsure how to incorporate that into a nested IF, or if that's even what I need to do here.

So have a column for Manager Approval (text) and an Approval Date column (date). I want to look in the Manager Approval Column for "approved" and then look at the date in the Approval Date, and calculate the date of the following Tuesday, and that would be stored in a new column.  If the Manager Approval is anything but approved, I'm happy with some text saying Pending Approval, in the event that I need a negative option for the output.

This is the date function that I have working that calculates the following Tuesday based on the Approval Date.  This works, I just need to get it to look at the Manager Approval as well.

=IF(ISDATE([Approval Date]1), IF(WEEKDAY([Approval Date]1) = 3, [Approval Date]1 + 6, [Approval Date]1 + WEEKDAY([Approval Date]1) + 2))

Thanks in advance!

Kelly

Tags:

Comments

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    You just need an AND statement

    =IF(AND([Manager Approval]1 = "Approved", ISDATE([Approval Date]1)), IF(WEEKDAY([Approval Date]1) = 3, [Approval Date]1 + 6, [Approval Date]1 + WEEKDAY([Approval Date]1) + 2))

    thinkspi.com

  • Thank you!  I tired some version of AND but obviously didn't have the right syntax.  Much appreciated!

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help. yes

    thinkspi.com

Sign In or Register to comment.