INVALID VALUE SUMIF Formula
I am trying to add the same base equation to a counterparts sheet which is almost identical to mine, but has slightly different column names. We are trying to create a "Biweekly Sum" column that sums the "Grand Total" / "Talent Paid" linking "Vendor Name or Slack Name" / "Pet Parent CP Name" or "Supplier Number" / "Vendor Number" with the same "Payment Period" / "Invoice Number". The equations have the same format and seem to be linking to the sheet but theirs outputs with #INVALID VALUE.
Best Answer
-
Hi @mpajuelo
I hope you're well and safe!
The main issue (it seems) is that you have one or more error messages elsewhere that are being referenced in the formula.
Was that the issue?
I hope that helps!
Be safe, and have a fantastic weekend!
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, Awesome, 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
-
Hi @mpajuelo
I hope you're well and safe!
The main issue (it seems) is that you have one or more error messages elsewhere that are being referenced in the formula.
Was that the issue?
I hope that helps!
Be safe, and have a fantastic weekend!
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, Awesome, 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.
-
Thank you, the error was there was no value in the "Talent Paid" column. I had to add to my equation in that column that if the "Number of Pets" column was blank then this column is to equal 0.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!