# IF(ISBLANK) Formula help

Options

I have three columns that I want to do some calculation on.

DAYS, HOURS and PARTIAL DAY HOURS

The formula is in the HOURS column and looks to the PARTIAL DAY HOURS column to see if its blank. If its blank I want to take the value in days and multiply it by 8. If the value in PARTIAL DAY HOURS is NOT blank then I want the Value in PARTIAL DAY HOURS in the HOURS column. I've tried the following but its just not working for some reason

=If(ISBLANK([Partial Day Hours]@row), ([Days]*8)@row, [Partial Day Hours]@row)

Its probably something very subtle I'm missing but I'm not seeing it

• ✭✭✭✭✭✭
Options

I hope you're well and safe!

Try something like this.

```=IF([Partial Days Hours]@row = "", Days@row * 8, [Partial Days Hours]@row)
```

Did that work/help?

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

I hope you're well and safe!

Try something like this.

```=IF([Partial Days Hours]@row = "", Days@row * 8, [Partial Days Hours]@row)
```

Did that work/help?

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

Thanks Andree...you have made my day! I was trying to be complicated where simplicity was the key. Appreciate your timely response! That worked great.

• ✭✭✭✭✭✭
Options

Excellent!

You're more than welcome!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!