-
Need a option to copy only changes for last 7 days
There is a good option to review changes in last say x hours and day , I would like to know how to copy all rows where last changes happened for that filter to only copy and paste to someone asking for delta work for last say 7 days ?
-
INDEX/MATCH function doesn't return exact match.
I'm having and issue with the MATCH function not returning an exact match. If my understanding of the formula is correct: "1" for the [search_type] should find the first value greater than or equal to the search_value starting from left to right, or top to bottom. "-1" should find the first value less than or equal to the…
-
Help with VLOOKUP
I am trying to pull data from one sheet into a summary sheet. Basically I am looking to pull if a given site met a target on a given day -- an admin is entering in the number of employees reporting for work on a day for each of 12 sites into a Smartsheet (called KU MR Attendance), and I need to see if they are meeting the…
-
select all fields when using the "Alert someone" workflow
Does anyone know a way to select all fields when using the "Alert someone" workflow? For "Send Rows" or "Update Request," there is an "All" that you can select to select all fields. In the "Alert someone" workflow, I want to select all fields and only deselect the fields I don't need.
-
Is there a formula/function to help count number of children assigned to specific parent tasks?
Hi all, I'm trying to put together a table that lists the number of sub-tasks (children) in each respective Workstream (parent) of a specific Project Plan, and also breaks these down into their respective Health Status (Green, Yellow, Red). I am aware that I can apply a "COUNTIF" formula and set the range to encompass the…
-
Numbers separate by commas read as thousands
I have ONE cell with various numbers/text that users get to input via a form. The input varies from all numbers separated by commas or can have some text as well. If it is just numbers separated by commas and there are no spaces in between those numbers and commas then cell is read as number. I need some sort of a way /…
-
Pulling Multiple Rows of Data into 1 Cell
Hello, Does anyone know how to pull multiple rows of data into one cell? I'd like to build a cell that look-up the date "05/20/20" and brings all the values into one cell. I'm thinking vlookup: =VLOOKUP("5/20/20", {Test Range 1}, 2, false) + " - " + VLOOKUP("5/20/20", {Test Range 1}, 3, false) + " - " + VLOOKUP("5/20/20",…
-
Using Smartsheet as a datasource in Sql Server Report Builder
Hi there. To keep it simple, I'm looking to use Smartsheet as a datasource to build an SSRS report. Has anyone done this successfully? If so, are there any special needs such as a driver to pull it off? Any knowledge on this is appreciated. SB
-
Proper Syntax for IF and VLOOKUP
I am trying to create a formula that will run VLOOKUP if a cell is blank This doesn't error but it leaves the formula field blank =IF((USERR3 <> ""), (IF((VLOOKUP(SDR3, {SFDCUsers Range 1}, 2, false)) = 0, "No", "")))
-
Dependency based on Status rather than Dates
Is there functionality available, in Grid View, that will allow you to identify tasks as dependents of other tasks, based on a Status field rather than a date column. We have many task related projects that are not tracked by dates but are tracked by status.