create a formula

Bridor

I try to learn how to create a formula that says : if the cell is not blank, create this.

actually, I have a row ID generated with this :

=IF([ID de ligne]@row = ""; ""; "OFFRE" + "-" + [ID de ligne]@row) = OFFRE-043

I would like to create this ID only when the row [DATE DE L'OFFRE] is field.

Find more posts tagged with

Accepted answers

All comments

Nic Larsen

I think this is what you're looking for.

=IF(ISBLANK([DATE DE L'OFFRE]@row); ""; "OFFRE" + "-" + [ID de ligne]@row)

Bridor

thank you again Nic…how should I understand it ?… because the value is true, it gives the false option ?

Nic Larsen

It looks at the column (date de l'offre) and asks is it blank? If it is, then leave the cell blank. If it is filled in (there's a date), then complete the function of adding Offre plus the dash and the number in the other column together.

Bridor

thank you for that…

Nic Larsen

You bet. Is that what you were wanting it to do? Or does it need to be changed?

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.