Using sheet summary fields within sheet formulas
Hi, I have a problem where I am trying to use smart sheet to generate the sell price of products based on a fixed % margin. Using a margin that is fixed is simple, I just put the value into the column formula. However, if I want to adjust the margin, I had hoped to use the sheet summary to do this.
I have used sheet summary fields before in formulas, adding together various values, and it worked. However every time I try and use any kind of mathematic equation that is not a simple addition, the formula spits out "INVALID OPERATION".
Example:
=1 + Margin# works
=1 - Margin# invalid
=BUY@row * (1 - Margin#) invalid
Any ideas of other workarounds?
Answers
-
I hope you're well and safe!
It should work!
Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.
I hope that helps!
Be safe, and have a fantastic week!
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.
-
Bizarrely, it has started to work. I rang a colleague to get an opinion and before the call it was failing, but when I tried to show them it started functioning!
-
Excellent!
Glad you got it working! A glitch in the matrix! 😉
Happy to help!
✅Remember! 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.
-
I have found the glitch, it is * I think * to do with the column properties of the sheet formula field.
You can see on this when I try it with different fields what was happening, but when I "Clear Field" and type again, even if I have previously copied the value that did work, it works?! The field property on all is set the same.
Just a glitch as you say.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!