-
Can IF(INDEX(MATCH())) return true for multiple rows?
I'm trying to develop a formula for the Booked column that will return true if the value in Date/Time is found in another sheet. That much I can do, but my problem is that the timeslots are 4 hours long so I need it to return true for the three following rows as well. For example, if the first timeslot (9:00-1:00) in the…
-
Sorting Rows
My team and I are adding rows to a sheet. I want to be able to sort the rows of information based on the date the rows were added. As a result, I sorted the rows according to the date they were created and saved the sheet. As each of my team members adds new rows, the rows are reordered. How can I keep this from happening?…
-
PMT calc
Is there a similar function to PMT? =PMT(rate, period, pv, fv) etc? Have not been able to find one. Thank you.
-
Change Cell Workflow across sheets
I know that some of this can be achieved with linking and some manipulative formula but I think it would be great (at least for me ;-)) if there was the ability to change the content of a cell on one sheet from an automation on another. My scenario: I use a date/time based automation to copy pertinent cells from one of my…
-
Extract multiple pieces of a text string that meet a criteria - between parentheses
I want to extract both the 1234 and 4567 from this text string: "First set of data to extract between parentheses (1234) and second set of data to extract between parentheses (4567) and that is it" I am able to pull the 1234 with this formula: =IFERROR(MID([TEXT_COLUMN]@row, FIND("(", [TEXT_COLUMN]@row) + 1, FIND(")",…
-
I am looking to use an Index match to concatenate a persons roles
I have a sheet to track workers roles however, some people are listed multiple times as they have multiple roles because depending on the project their role is different. I was wondering if there was a way to use an Index(match( to either concat all of their roles in 1 formula without the use of a helper column. My current…
-
How can I add a Confidential Statement to the top of my Smartsheet
I would like to add a Confidential Statement- Do Not Share.... at the top of a simple Smartsheet. Preferably at the Very top under the Name of the document. Users will only have View Only Permission.
-
See Row Update Requests
Can you see a row update request someone else sent? I would like to be able to monitor requests from my team if possible, so they aren't duplicated. I've looked in the activity summary, but they don't live there. Thanks in advance, Regina
-
Merged: Visibility of total number of Cell References, as well as early warning when a sheet is clo…
This discussion has been merged.
-
VLOOKUP across Multiple Sheets
I am trying to have a cross reference that looks across 3 different sheets. I have been successful getting it to work with just two sheets, but when i add the third, it comes back "INCORRECT ARGUMENT SET". Any help is appreciated. Here is my formula =IFERROR(VLOOKUP([Employee Email]@row, {Supervisors 1 Range 1}, 2, 0),…
