What formula to change cell using IF(AND(
Im trying to create a formula that changes my status (Ref. Only) column to "test" if true and "ok" if false; When true means that reorder point is >= On Hand QTY AND Status column is blank…
is this possible?
Best Answer
-
PERFECT. That fixed it- thank you!
Answers
-
The formula in your screenshot is close. Remove the @ from before "Status9" and then take one of the closing parenthesis from the end and move it to after the closing parenthesis following the ISBLANK function so that you close out the AND function before moving to the outputs of the IF.
=IF(………………………………., ISBLANK(Status9)), "TEST", "OK")
-
PERFECT. That fixed it- thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives