-
Formula and RYG balls
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 show how complete a project currently is i want Red balls to show projects that are less than…
-
RYG with vlookup
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","Green"),if(vlookup([Employee #]1,{EIC Range 3},8,False)="Not…
-
Formular to show tasks marked 100% in past 7 days, 30 days by user
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. Glad of help
-
Countdown from today not working
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 really helpful for me. I have turned on and off the duration function, it gave me a…
-
Sum If formula question - Don't want to sum if it's a loss
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 filtering to just sum up the weighted forecast for John Smith but I want to exclude anything…
-
How to count within a date range in first column and with a specific criteria in a second column
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],AND@cell>=DATE(2018,1,1),@cell<=DATE(2018,3,31))) Thanks ahead of time for any thoughts!
-
Today(-xx) function in Cross Reference sheet
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 date is greater than the LAST entry in Date Cleaned, I want a name to populate, otherwise "do nothing". The "Date Cleaned"…
-
Number of duplicates
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
-
Unexpected behavior. (Found the Issue)
[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 of formulas. That said, information is below. Background: I am trying to optimize a set…
-
Multiple IFS
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 "" if no, or that same value ("IFC") if yes. I want to continue and test the same range for…