HELP ON FORMULAS

hderryberry
hderryberry ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I am trying to create a formula that will change the production status automatically. My [production status] column is a drop down box with these options "Roof Ordered, Roof Delivered, Roof Building, Roof Complete". My other columns are date columns, so when the column [Roof Delivered on] has a date in it I want it to change the production status to "Roof Delivered. I created this formula in the [production status} column =IF(ISDATE([Roof Delivered On]@row), "Roof Delivered") and that worked but how do I add the other columns ([Roof Ordered On], [Roof Building On],[Roof Complete On]

Thank You

Heidi

2019-10-04 (2).png

«1

Comments