Best Of
Re: Basic Subtraction
@ahw47 It's possible one or both of your columns are storing the numbers as text. Wrap the column references in the VALUE() function to ensure you are operating on numbers vs text.
This especially is plausible if you are importing the data from another system or copy and pasting it in.
=value([Amount Invoiced]@row) - value([Amount Paid]@row)
Darren Mullen
Re: Option to Not Include Sheet Link on Notifications
Everything is always on the radar but this is something I think we truly need!
AngB789
Unique() or Distinct() function for finding unique values
Hi,
It would be very helpful if Smartsheet redesigns the DISTINCT function so it can be used not just as an argument, but also at the top level to pull all unique values from a column.
For example, if a column titled Customers has many duplicate names, we should be able to use a formula like:
=DISTINCT([Customers]:[Customers])
When converted to a column formula, it would dynamically return a list of unique customers.
Without this, we have to create multiple complex formulas to achieve the same result, which is very cumbersome.
A major benefit of this capability would be the ability to use (for example) the RANKEQ() function to quickly find the order in which our customers spent the most on our products or services.
zealvert
Badge Notification in Smartsheet University
Ii would be a great addition to receive a notification once a badge path has been started to bring awareness to the goal and encourage the customer to complete it.
A notification of how close they are to the goal would be a great feature as well, such as when Smartsheet University will send a reminder email that a course was started and needs to be completed.
Shaq McWilliams