IF #INVALID OPERATION

Hi I am using this formula to define Health of the project with symbols in the summary sheet

=IF([Gap vs SMS]15 >= 14, "Yes", IF(14 > [Gap vs SMS]15 >= 0, "Hold", IF([Gap vs SMS]15 < 0, "No")))

Formula works ok, but when I copy to other sheets, a few of them appear with invalid operation and I can´t find what could be different.

any ideas?

Thanks!

Rosario

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @Rosario Barros

I hope you're well and safe!

Make sure the column names are correct, and then try something like this instead.

=IF([Gap vs SMS]@row >= 14, "Yes", IF(14 > [Gap vs SMS]@row >= 0, "Hold", IF([Gap vs SMS]@row < 0, "No")))

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

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

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

Rosario Barros

Hi! Thanks for your reply. That doesnt seem to be issue. Right now, i realize that the formula only worked when the result was under yes...for the rest is showing me invalid operation..

is the formula wrong?

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.