Keep the text in a cell if is not blank but if it's blank then add "N/A"

Hi everyone,

I'm trying to find a function or formula, where if in one cell, someone log information, leave the information like that, but is there is not log information, add a "N/A". This is for daily entry data, to generate a daily report, where if nothing happened in a section, to automatically add "N/A", but if someone log information, leave the information as it is.

Thank You

Find more posts tagged with

Accepted answers

All comments

Mike TV

@EmilyEchevarria

=IF(ISBLANK([Column1]@row), "N/A", [Column1]@row)

This will look at the column/row you point it to and if it's blank write N/A and if it's not blank it will write what was written in that location.

DKazatsky

Hi @EmilyEchevarria

This can be done with a Workflow as such...

Where I have "Primary Column", you use the appropriate column. You can change "Run workflow" to best suit your needs.

Hope this helps,

Dave

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.