nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

INVALID COLUMN VALUE

Abdulhameed Babalola

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)

Find more posts tagged with

Comments

Mike Wilday

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.

Chris McKay

Hi Abdulhameed,

I can see a couple of issues here:

As Mike pointed out, you do not reference columns in the same way you would in Excel. Instead of A2 for example, you would use [Column Name]2
You also seem to have a ( before your equal sign. Was that just because you're displaying it on the Community forum, or is that the case in your sheet? There should be nothing before your = sign otherwise Smartsheet will not recognise it as a formula.

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

Sign in to join the conversation!

Quick Links

Trending discussions

Link to Download Attachment Missing
Hi, I have automations in place to generate various documents, based on the form completed. Once the document is generated, the user WOULD receive an email that included a message I create and then a link (at the very bottom) for the recipient to click on to download the generated document. Now, I still get the email but…
Safe Sharing Audit
Is anyone aware of a method to inspect the login history of individuals added to your Safe Sharing Exempt List? We feel it would be wise to audit this periodically and then disavow anyone who has not logged in after x months
Solve for Sending rows without Linking to Sheet
Hi! We have a project list that goes through our SteerCo for approvals on Wednesdays. I have an automation that sends all approval decisions from the meeting to the stakeholders following the meeting (set an hour after meeting conclusion). We have it set up so that only a couple admins can see the main sheet, all other…