IF(ISBLANK) Formula help

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

Thanks in advance

Find more posts tagged with

Accepted answers

Andrée Starå

Hi @John Kostenbader

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!

All comments

Andrée Starå

Hi @John Kostenbader

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

John Kostenbader

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.

Andrée Starå

@John Kostenbader

Excellent!

You're more than welcome!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.