ISBLANK Question
I have a column formula which deducts 7 from another date field. I however want an override and so if the ACTUAL date is populated, to use that date. I receive an error saying invalid argument.
=ISBLANK([Actual ship date]@row,[Delivery Date]@row- 7, [Actual ship date]@row)
Best Answer
-
Hello @wayneFor,
I think you are just missing the IF statement required at the beginning of your formula and we also need to close the ISBLANK function.
I believe you are looking to ask IF [Actual Ship Date] is blank then show [Delivery Date] minus 7 days, else [Actual Ship Date]. If so I think the formula below should be useful to you.
=IF(ISBLANK([Actual Ship Date]@row), [Delivery Date]@row - 7, [Actual Ship Date]@row)
I hope that is helpful in someway,
Protonsponge
Answers
-
Hello @wayneFor,
I think you are just missing the IF statement required at the beginning of your formula and we also need to close the ISBLANK function.
I believe you are looking to ask IF [Actual Ship Date] is blank then show [Delivery Date] minus 7 days, else [Actual Ship Date]. If so I think the formula below should be useful to you.
=IF(ISBLANK([Actual Ship Date]@row), [Delivery Date]@row - 7, [Actual Ship Date]@row)
I hope that is helpful in someway,
Protonsponge
-
Thank you. I messed up the parenthesis. Thanks for your help
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!