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

Grouping in reports does not show headers of the drop-down list
Hi I am a new user trying to test and see how much I can pull off from this amazing sheet. Well, I am trying to create a report with all the tasks for any given stakeholder. I am grouping the report based on the primary field that has values within a particular header as in the ss below: And, if you look at the report, it…
What do I need to enter for my 2nd criterion range in an index-collect formula?
Hi all, I'm looking for help with an index-collect formula. I want to collect the venue name from an existing sheet using the project name as my criterion. The problem I'm running into is I'm not sure what value to enter for the second criterion range. Below is the formula I currently have, which I know is incorrect. Any…
Countifs for a specific month
The AI-generated formula shows an invalid data type. I'm not sure what is wrong. What I want to do is count the number of items that are good for the month of December. =COUNTIFS([Fault Severity]:[Fault Severity], "good", MONTH([Last Update]:[Last Update]), 12)