If not blank formula for 2 column options + result as a sum formula or 0
Hello,
I am trying to make a formula where if "Drug Selected/ Wrong drug (0)" is not blank or "Patient profile / wrong patient (0)" is not blank then the return value is 0 and if it is blank then there is a formula where it adds up the value remaining columns.
Would anyone be able to help me with making this formula?
Thank you for your help in advance
Answers

Try something like this: =IF(AND(NOT(ISBLANK([Drug Selected/ Wrong drug (0)]@row)), NOT(ISBLANK([Patient profile / wrong patient (0)]@row))), 0, SUM(the other fields you want to add up)) Hope that helps.

Thank you, I tried the formula however the return value is not 0 when the "Drug Selected/ Wrong drug (0)" column and or "Patient profile / wrong patient (0)" column are not blank. I still get the sum value of all the other columns instead. If either of these columns have any number then the result of the formula should result in a zero or the sum of the all the other columns.
Edit: the formula below worked, had to use OR instead of AND
=IF(OR(NOT(ISBLANK([Drug Selected/ Wrong drug (0)]2)), NOT(ISBLANK([Patient profile / wrong patient (0)]2))), 0, SUM(prescriber2+
sig2+[dispense quantity]2+repeats2+[days supply]2+[Hard copy documentation]2+[Billing Procedure]2+[Auxiliary Labels]2+Questions2+[Evaluation (total out of 5)]2))Thank you for your help in advance!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K 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
Check out the Formula Handbook template!