-
Why am I observing this odd behavior with a "Created (Date)" column?
I think I've found a bug. I have a column that is of type "Created (Date)" called "Date" and another column called "DATE TEXT" which is a text column. DATE TEXT = Date + "" DATE TEXT is calculated by appending a null string to Date. I have noticed erratic behavior in another sheet that references this column, and I believe…
-
multiplicate row if a multiselect field contains more than one value
Hi community, I would like to multiplicate rows depending on the values of a multiselect field "Values". e.g.: 1) field multiselect "Values" can contain a, b, c 2) if a single value a, b or c is selected, there is no need to multiplicate the row 3) if more than one value is selected 3a) the original row should remain 3b)…
-
Licensed vs Admin status
Does anyone else have a challenge with this mix of functionality? As a "free user" with admin access to a sheet, someone can move or copy entire rows somewhere else. But that same user cannot lock a row or columns. (And, while I am at it, there is no workflow that allows programmatic locking of columns). (This became an…
-
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",…
