or Explore Discussions

# Formulas and Functions

Archives for August 2018

## Discussion List

• Formula and RYG balls
In Formulas and Functions
HELP!!!!!! How do i create a formula to use RYG balls in the status column with % Complete column no matter how many videos and threads i look through!!   I have a status column I also have a % Complete column I want to use balls to sho…
1671 4
1.7K views 4 comments Most recent by J. Craig Williams Formulas and Functions
• RYG with vlookup
In Formulas and Functions
Hello, I need my sheet to lookup an employee's id number on a second sheet and return a RYG ball depending on the code in the 8th column. I tried this with no luck: =IF(VLOOKUP([Employee #]1, {EIC Range 3},8,False)="Yes","…
14 1
14 views 1 comment Most recent by Paul Newcome Formulas and Functions
• Formular to show tasks marked 100% in past 7 days, 30 days by user
In Formulas and Functions
Hello, I am trying to add formular to sheets to show the tasks that have been marked 100% for each user in a certain time period, ie past 7 days, or 30 days etc. This data will be shown in a widget on our report page for team dashboard.  …
68 1
68 views 1 comment Most recent by Paul Newcome Formulas and Functions
• Countdown from today not working
In Formulas and Functions
I am having the hardest time using any kind of formula...whenever I type them in I get the unparsed error. I am trying to do a countdown from today to an end date but no dice. I find the explanations on here for how functions work aren't r…
159 5
159 views 5 comments Most recent by Paul Newcome Formulas and Functions
• Sum If formula question - Don't want to sum if it's a loss
In Formulas and Functions
Hello! I'm currently using a Sum If formula that works to sum up by each lead, however, once we turn the Sales Stage to Loss I would like to remove the losses from the sum for that person's weighted forecast. The formula below is filterin…
22 3
22 views 3 comments Most recent by J. Craig Williams Formulas and Functions
• How to count within a date range in first column and with a specific criteria in a second column
In Formulas and Functions
I want to figure out how many times a specific person sends an application out within a specific date range. Here is the formula I tried:   =COUNTIFS(Name:Name,"Jane",[Application sent]:[Application sent],[email protected]>=DATE(2018…
12 2
12 views 2 comments Most recent by KO_in_Colo Formulas and Functions
• Today(-xx) function in Cross Reference sheet
In Formulas and Functions
I am trying to make a Primary sheet for all of my escalation formulas (since i have 14 single sheets to use the TODAY() function).   so...   if(TODAY(-7)> {Date Cleaned}, "enter a name", " ")   so if today's da…
14 14
14 views 14 comments Most recent by Elizabeth Aird Formulas and Functions
• Number of duplicates
In Formulas and Functions
Hello,  I'm brand new to Smartsheets. Is there a way to find the number of duplicates in a column for a specific value? For example, how many "John Smiths" are in a list of names?  Many thanks, Pltrmgrl
1010 13
1K views 13 comments Most recent by Chris Jernigan Formulas and Functions
• Unexpected behavior. (Found the Issue)
In Formulas and Functions
[Update: I've found the solution and posted it in a comment]   I am having some issues with a very complicated set of sheets I have created. Please be warned, I am stressing the limits of smartsheets, and it is a rather complicated group…
64 10
64 views 10 comments Most recent by J. Craig Williams Formulas and Functions
• Multiple IFS
In Formulas and Functions
Hi, this should be relatively easy I think, but I'm struggling. I have the following formula (pasted below these comments) functioning to test whether a certain value exists (IFC) within a range on another sheet, and then returning "&…
102 1
102 views 1 comment Most recent by J. Craig Williams Formulas and Functions