create a formula
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.
Answers
-
I think this is what you're looking for.
=IF(ISBLANK([DATE DE L'OFFRE]@row); ""; "OFFRE" + "-" + [ID de ligne]@row)
-
thank you again Nic…how should I understand it ?… because the value is true, it gives the false option ?
-
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.
-
thank you for that…
-
You bet. Is that what you were wanting it to do? Or does it need to be changed?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!