Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
I wrote a function for my budget, setting limit and i want it to return text either True or false. but it kept on returning "INVALID COLUMN VALUE"
(=SUM(A3:A10)<=(0.7*D6)
https://help.smartsheet.com/articles/2476176-formula-error-messages#invalidvalue
This post which describes invalid value might make sense.
Are you trying to sum data only if it is less than or equal to 0.7*D6? If so, you should look at SUMIFS, to designate criterion for summing the range based on the criterion. https://help.smartsheet.com/function/sumifs
Also, you should be aware that Smartsheet does not refer to columns as letters like in Excel or GoogleSheets. You should use the column names and include brackets if the column title has white space or ends in a numeral.
Hi Abdulhameed,
I can see a couple of issues here:
If you're looking for a TRUE or FALSE condition to to decide whether a value should be included in the sum, then try this:
=SUMIF([Column Name]3:[Column Name]10, <= (0.7*[Other Column Name]6))
Kind regards,
Chris McKay
Over the past 2 weeks, about 10 people have had a problem trying to submit different forms. I've walked them through the process and none of them did anything wrong. We've opened support tickets but nothing had been resolved. Anyone else having this problem?
Recently i have been seeing "Form Unavailable" show up on Forms taht have worked without issues for ages. I thought it might be connected to Table View, but I am not sure for certain. One is on a newly created form and the other is on a sheet that I converted to Table view, because we were hitting the 500K cell limit (so…
Hello community, What can we do if I cannot delete the data shuttle workflows that I created myself? Thanks!
