-
VLOOKUP Questions
I've got a basic handle on VLOOKUP but what I am trying to do is a little unconventional due to sheet row limitations within smartsheet. We have a sheet in which people will fill in a part number, each part number has a part description. What I want to do is automate the part description field. So I want to use a VLOOKUP…
-
Help needed counting across sheets
Hi all, I am trying to use the count of a symbol across some sheets. I know I can get this information by creating a report but for a more visual presentation, I am looking to get an actual number. I am currently trying something like this but it's not working: =COUNTIFS({sheet 1 Range 1}, 1, {Sheet 2 Range 2}, 1) The…
-
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()",…
