-
Pulling Approved Data from an Approved Row to a Version
I have talked to Smartsheet Support on this one, but I am under a time crunch, so I was hoping one of you Smartsheet wizards can help me solve the following situation: I have a Tracker sheet that contains requests that go through an review/approval workflow Once approved, there is a 'Latest Approved' column (checkbox) that…
-
Row limits in Reports / Grouping
I am pulling data from 2 different sheets that currently span about 5,000 rows with more to come. When I create a report looking to group the information certain ways it seems that the row limit inside the Report itself is 2,500, is that correct? When the data is grouped, I cannot uncollapse the groupings unless it is…
-
Changing WEEKNUM formula to pull on Sunday's instead of Monday's?
Hello, I have a sheet that acts as a "day tracker." Each row is a new date that tracks specific data in each column. I have a "Week Number" column attached to the "date" column, however the week number populated does not match the week number shown in Outlook calendar and Excel. I think this is because Smartsheets starts…
-
Column Formulas
Hello, I am putting column formulas on a sheet, which I'm excited about. However, we had a top row that had some explanations for users i.e. whether a column was Required, Admin only, and this one that has been super helpful to find people what RYGB stand for rather than having them interpret for themselves. "Status"…
-
Need help with Countifs formula
Hi. Can you help me with this formula? Essentially I want to count the number of positions that have the criteria "Filled" in one column, but also have to have the date 04/17/20 in another column. This formula is not working and I have changed slight variations with commas, "=" and parenthesis and can not make it work. Can…
-
Getting characters from before and after a text
Hi, I have this value in a cell. I need some help to create a formula that can find the last '$' sign and get maximum of 4 number after the '$' sign and 6 numbers before the '$' sign from the data below. "FB12345 $12345 ABCD 12345 SC FB12346 $1234 ABCD 12345 SC FB12347 $123 ABCD 12345 SC FB12348 $12 ABCD 12345 SC" The…
-
Return Multiple Values with Index/Match or VLOOKUP
Hi all, I'm working to develop a system where Smartsheets will collect all matching names (First Last in the same cell) and list them together based on what company they work for (listed in an adjacent cell). INDEX/MATCH shows promise, I've used it before as an array formula in Excel however in Smartsheets I cannot figure…
-
If Column 1 contains "Yes", Vlookup data from Column 2.
Hi Community, I want to lookup data, based on data on my current sheet, If Column 1 contains "Yes", Vlookup data from Column 2. IF Column 1 CONTAINS "YES" VLOOKUP Other Sheet Reference,2,false Any way to do that? Thank you in advance! 😀
-
Formula to change status symbol if a task is not completed before due date
Thanks guys, new to Smartsheet and need some help... Having issues with changing the status symbol to Red, Yellow, Green, or Gray based on project completion percentage column (%Complete) and start/due date columns ("Start Date" / "End Date"). I would like the following: Gray - If %Complete equals to 0 and start date has…
-
If(OR(AND statement
little help - been working on this too long If the %complete is100%, ie. =1 then the ball should be gray no matter what If the job is not 100% and finish date has past, then red, If the job is not 100% and finish date is within 7 days, then yellow, otherwise green =IF(OR(AND([%Complete]@row = 1, "Gray"),…
