Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Weeks Out Calculation based on Nested IF Statement

edited 12/09/19 in Archived 2017 Posts

I'm having trouble having my weeks out calculation work based on the results of a Nested IF Statement. The If Statement works if I use quotation marks around the results which need to display a date. The problem is that putting the quotes around the results converts the number (in my case a date) into text and no longer feeds the second formula of calculating weeks out. My nested IF Statement which posts results to a column entitled "Market Start Date"

=IF([AW Market]1 = "Europe", "3/19/18", IF([AW Market]1 = "LATAM", "2/12/2018", IF([AW Market]1 = "APAC", "7/30/18", IF([AW Market]1 = "Asia", "5/14/18", IF([AW Market]1 = "New York", "10/1/2018", 0)))))

The weeks out formula is below:

=-ROUND(([Start Date]1 - [Market Start Date]1) / 7, 0)

I assume I need to modify the if statement such that it produces a result that is a date and that the column property would need to be defined as a date as well? Thanks for the help anyone!




This discussion has been closed.