-
I need away to deal with null values in a formula.
I have a simple formula that gives a score a value. However I need an addition that checks to see if the cell is blank and if so this row should also be blank. My issue is the NULL is showing up as 0 and populating a "Low" rating. Formula: =IF([Inherent Risk Score]@row > {Key Range 3}, "High", IF([Inherent Risk Score]@row…
-
Email Notifications
Is there a way to change the header of email notifications when it says: "Name" via Smartsheet? Can that be changed to the person who submitted the form?
-
SUMIF that include unique values?
=INT(SUMIFS({Value}, {Sheet}, "GLS", {Lease Exp. Date}, AND(@cell >= DATE(YEAR(TODAY()) - 2, MONTH(TODAY()), DAY(TODAY())), @cell <= TODAY())) / 1000000) It's adding repeated projects, such as AO987. There can be 3 AO987 which is $78,000, but instead of counting it 3 times, I need it to only count it once. How do I sum…
-
VLOOKUP and #NO MATCH
Hello! I'm having a strange error using VLOOKUP with a reference sheet. Some of the fields are matching but others are returning a #NO MATCH error. I believe that all my spelling, etc is uniform across the sheets, but please review that as well. Thanks in advance for you help!
-
Contact List
So I am trying to show only the person's first and last name along with their email. I have them enter their email address in the form, so is there a way to get their name in a different column so I don't have to have them enter it?
-
Is there a way to shorten the numbers? So instead of $789,137,674.05 It can be 789 and the title say
million? I'm pulling data from else where, but I'd like to shorten it so it's easier to read. Here is the formula so far: =ROUND(SUMIFS({Value}, {Sheet}, OR(@cell = "REXUS Activation", @cell = "Pending REXUS"), {Lease Exp. Date}, AND(@cell >= DATE(YEAR(TODAY()) - 2, MONTH(TODAY()), DAY(TODAY())), @cell <= TODAY())), 2)
-
Nestled IF Formula(s)
I'm sure this is simple, but I can't seem to get it. I'm trying to have the Partial Billed Dollars show in the AR column if Billed column contains a date. But once Paid column contains a date, I need that AR column to show Blank. This is done on the "child(ren)" level. I have a formula that SUMs the children. I appreciate…
-
COUNTIFS
Hi, Not sure of the best method or formula, but I am trying to sum up (in column61) the total number of days worked in the last 2 weeks for everyone when the data looks like this: I can do a countifs statement that returns the number of weekending dates that are within 2 weeks of the current rows weekending date, but not…
-
Have a box checked based on another sheet
Hello! I have a main sheet that I would like to have the checkbox checked if a second sheet has a checkbox checked. So if the second sheet has the checkbox checked it would match with the main sheet by the description. Make sense? Any ideas on how I can do this? Thanks!!
-
Auto-Number conditioned
Hello, I need to create an auto-number field with these characteristics: Prefix: 2 digit from the alphabet (start with AA). Fill: only 3 digit from 001 to 999. When I'll reach 1000, how I can increase the second letter of the alphabet of the prefix and restart to 001 (example AB001)? At same time when I'll reach Z, how I…