Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Basic percentage formula

Graeme Baker

Graeme Baker ✭

02/14/17 edited 12/09/19 in Archived 2017 Posts

=SUM[Invoiced Jobs]2:[Invoiced Jobs]50*0.2)) ..Not working ???

0 ·

Comments

Graeme Baker ✭

02/14/17

Try to say =SUM[Invoiced Jobs]2:[Invoiced Jobs]50 X 2%))

0 · Share on Facebook Share on Twitter
Jose Joaquin Pastor ✭

02/15/17 edited 02/15/17

Hi Graeme,

you have the 2% inside the parenthesis of the SUM. Take it out and it will work
=SUM([Invoiced Jobs]2:[Invoiced Jobs]50)*0.02

Regards, José Joaquín.

0 · Share on Facebook Share on Twitter
Graeme Baker ✭

02/15/17

Thank you Jose

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Custom Report View
I have a report that is pulling information from a sheet. Is there any way to set this report up so that anyone that views it only sees the rows with their name on it?
I have the Year and Month on a sheet. How can I have the summary look at both to count?
I would like to create a summary if the month is Sept AND the year is 2024 to count. I have found that I can use the and but keep getting an error message This is the Formula I have in the Summary that is coming up #Unparseable =COUNTIFS([Next Renewal Year]:[Next Renewal Year], "2024") AND(([Next Renewal Month]], "Sept")
Formula Help
Hi All - I am hoping someone might be able to help me. I am terrible at formulas and I cant seem to figure out how to pull what I need on my own so I copied a formula from another sheet we have at our company. The issue is that it returns it multiple times. So the expected result is "four", the formula returns "four"…