-
Mark Duplicate value
Hello team can someone suggest a simple way to mark cell (or rows) that one of the columns with Duplicate value thanks in advance oded
-
How do you exclude a specific status from another sheet in a formula?
Hello! I'm having trouble finding a way to exclude a status from this formula: =IF([Total on PTO]@row < 2, "Under Limit", IF([Total on PTO]@row = 2, "At Limit", "Over Limit")) It's referencing another sheet for PTO requests. The limit is including requests that have been withdrawn, but we don't count those as the actual…
-
How to mirror cells within the same sheet
I'm trying to have to two columns with the same information. One of them should be used in the update request forms and be available for edit in the form. The other one will be used with the predecesor tool and remain hidden (to avoid having two columns with the same information in the sheet). This one should reflect the…
-
IFERROR Not working for NETWORKDAY
Here is the formula I am trying to use, ideally the cell would just be blank if there was an error. I've tried rearranging in almost everyway I can think but I still keep getting #UNPARSEABLE. =IFERROR(NETWORKDAY([Estimate Status Date]@row,[Proposal Sent]@row)"") Thanks in advance!
-
How to sum all the numbers where there is a letter together with the numbers in the cell?
Hello, I need some help adding all the hours in the range, but in each cell there will be a letter: I need to get '20' without any letters. Is it possible to do? Thank you in advance!
-
Unique filter
Can someone help me with the below formula? I am trying to count unique values within a column that also have a specific condition. =COUNTIFS, DISTINCT({CBA - Master Range 4}, {CBA - Master Range 2}, "Accepted", {CBA - Master Range 1}, =Title@row)
-
Index Match inbounce limitation?
Hi, As I known that Vlookup has a limitation that cannot reference more than 100,000 cells and cannot have more than 100 unique cross sheet references in one sheet.(https://community.smartsheet.com/discussion/68137/vlookups-in-smartsheet-are-there-limitations) Question : I have a table with 7 columns(1 for identifier/6 for…
-
Extracting multiple lists by category
Hi. I have a master sheet where each row is allocated one of four categories. I would like to extract this data into another sheet, into different columns dependent on the category (i.e. four columns for name, one per category, four columns for date, one per category). All the functions I have tried (vlookup, match/index…
-
Question on using Sumifs
I'm trying to create a sheet that will calculate the sum of a referenced sheets based on a condition. The first column of the range is "status" and I want to report only "ongoing" statuses, the second column I want to use is "hard savings or soft" and only report "hard", and I'm trying to report the sum of the values in…
-
COUNTIF statement - if there is a number greater than zero then it counts as one
I think I need to use a countif statement but I am unsure how to incorporate this formula. If there is a number in one of those cells greater than zero under the 'Service Type', 'Project ID', 'Project End Date', 'Reason for Termination' or 'Resource posted time?' columns then for that person in the PRM column it should…