-
Formula to display Red Flags
I am attempting to have a RED Flag populate in the "Risk" Column for cells where the "Available Space" is less than 10. Kindly when answering, please complete the entire formula from start to end as from research I tend to get bits and pieces as seen in my screenshot. Thanks,
-
INDEX/MATCH not working
Below are two screenshots. The first is a screenshot of my target sheet. The other is a screenshot of my reference sheet. On the reference sheet I have a list along the left. In the column to the right is: =TODAY() On the target sheet is an identical list with the following formula to the right: =IF(TODAY() = INDEX({New…
-
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…
-
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…
-
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
-
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…
-
Formula help please
Hi, looking for some help please. I want to count a financial figure when the status is not received. Columns i am using are Start up budget and Received status. Probably really easy for someone, but am struggling with formulas as quite new to Smart Sheets. Any help greatly appreciated. Thanks Dave
-
Formula Returning Today's Date IF Column is Value
Possibly a dumb question... I am trying to format a date cell to return todays date if a cell in the same row is marked "Completed" using the IF formula. I am using the TODAY() formula as a result in the IF string, however it looks like the today formula cannot not work in this way: =IF(Status111 = "Completed", "TODAY()",…
-
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…
-
Invalid data type/unparsable for date countdown
I'm trying to have an automatic countdown but I keep running into an invalid data type or unparsable error. I am trying to show how many days remain until a point in the future (07/17/2018). Here are some of the formulas I've tried without success: =NETWORKDAYS([timer start]1, [Minimum billing date]1) =[Minimum billing…
