Getting a total summation to be displayed only when all cells are populated
Hello,
I have 3 cells which I want to add to provide a total. I only want the total to be displayed when all 3 cells are populated, otherwise to leave black (in my total column). Is this possible?
Best Answer
-
Excellent!
You're more than welcome!
I assumed they were beside each other, and then all three columns would be included.
Are they not beside each other?
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
I hope you're well and safe!
Try something like this.
= IF(COUNTIF([Column 01]@row:[Column 03]@row, <>"") = 3, SUM([Column 01]@row:[Column 03]@row))
Did that work/help?
I hope that helps!
Have a fantastic weekend & Happy New Year!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andrea,
Thanks much.Its not going through. I tried using the below with my 3 columns:
=IF(COUNTIF([Duration(mins) In ER Prior to Trolly to Rad Dept]@row:[Duration from Arrival in Rad to Completion of CT]@row:[Duration from Completion of CT to Reading of CT]@row,<>"")=3,SUM([Duration(mins) In ER Prior to Trolly to Rad Dept]@row:[Duration from Arrival in Rad to Completion of CT]@row:[Duration from Completion of CT to Reading of CT]@row))
-
Happy to help!
Try this.
=IF(COUNTIF([Duration(mins) In ER Prior to Trolly to Rad Dept]@row:[Duration from Completion of CT to Reading of CT]@row,<>"")=3,SUM([Duration(mins) In ER Prior to Trolly to Rad Dept]@row:[Duration from Completion of CT to Reading of CT]@row)
Did it work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andrea,
Thanks again. This is only summing up 2 columns and not the third one. As you can see in the above formulla I am trying to complete. Can you say what I am doing wrong?
-
Excellent!
You're more than welcome!
I assumed they were beside each other, and then all three columns would be included.
Are they not beside each other?
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andree,
They are beside each other, but it only captures 2 column- see screenshot.
-
Hi Andree,
Just inserted again and it is now working well. Thank you very much.
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!