-
Incorrect Argument Set error when using Vlookup to reference another sheet.
I am using a Vlookup to use a row id in sheet A to lookup the corresponding row id in sheet B and return the value in the status column - the syntax looks correct to me but I am getting an Incorrect Argument Set error. This is the syntax I am using: =VLOOKUP([Row ID]@row, {Cutover Tasks Range - Row ID}, 6, false) Can you…
-
How to calculate using a 7 day workweek (to replace NETWORKDAY)?
I am using this formula to calculate the # of days it takes to get to a particular task called, Enable. Range 2 = %Complete and Range 1 = Start Date of Enable. It calculates correctly using 5 days per week. I am now being asked to count using 7 days per week. Is there a comparable function that I can swap out for…
-
Creating a unique ID based on two other columns
I'm trying to create a unique id based on values in 2 columns: partner and label. In our data, we have names associated with partners, but when we share data we don't want to share names, so instead I'd like to create IDs. As you can see in the sample below, we use two columns because names can be repeated between…
-
SUM formula with extending range
Is it possibly to have a SUM formula in a cell at the top of a column, calculating the sum of the contents of that said column, with the range beginning at a specific row but continuing to the bottom of the sheet and extending down as rows are added to the sheet automatically? It would obviously be easier for me to just…
-
Hyperlinks in Linked Cells and Cross Sheet Formulas
I'd love to be able to add a hyperlink to a cell that links in a value from another sheet. Currently we're unable to do this as linking cells blocks the ability to add a hyperlink. This would add more versatility, particularly with trackers, as you'd have the ability to pull in valuable information while also linking to a…
-
Merged: Cross Sheet Hyperlinks
This discussion has been merged.
-
Form to populate answers against unique ID
Hi Team, I need to collate data from employees for an upcoming project. Has the form got functionality to recognise unique identification between answers and link it to relevant row yet? My ideal sheet would have all employee names, their unique staff ID and relevant fields I will ask them to give me answers for via the…
-
Needing Two Timestamps in One Smartsheet
Hello, Can someone please assist with having two timestamps? I need to have our "Timestamp" in the first column when the customer submits a quote request, and another timestamp in "Arista Timestamp" (with date and time) of when "Quote Request Sent To WWT?" changes to "Yes". Right now my workaround is to have it record a…
-
Matching a Name to another sheet and is checking a row if it is a date
=IF(AND(MATCH([Team Member]@row, {Team Member}, 0), ISDATE({L1 Mixer})), 1, "") This is what I try and it returns incorrect argument set on the first row, but invalid data type on the remainder. It is a column formula.
-
If any of the cells being searched are not blank return a 1
=IFERROR(IF(AND(MATCH([Team Member]@row, {Team Member}, 0) > 0, COUNTIFS({Team Member}, [Team Member]@row, {L1 Mixer}, {L2 Mixer}, {L4 Mixer}, {L5 Mixer}, {L6 Mixer}, {L7 Mixer} <> "") > 0), "1", "0"), "Error") It is searching for all of them returning not blank. I am wanting if any of them are returning not blank.
