Check The Cell Before Displaying The Results

Kaleb

Smartsheet Community:

I Would Like to Add to my Existing Formula to Only Display Result If The Condition is Met.

Current Formula:

=$[Start Date]$1 + [TEAC (Days)]5

Objective:

Only Return Results if [TEAC (Days)]5 is a Number, Otherwise Blank.

Thanks

Kaleb

Disregard Smartsheet Community. I Figured it Out.

=IF(NOT(ISBLANK([TEAC (Days)]@row)), $[Start Date]$1 + [TEAC (Days)]5)

Kaleb

Disregard Smartsheet Community. I Figured it Out.

=IF(NOT(ISBLANK([TEAC (Days)]@row)), $[Start Date]$1 + [TEAC (Days)]5)

Kaleb

=IF(NOT(ISBLANK([TEAC (Days)]@row)), $[Start Date]$1 + [TEAC (Days)]5)