-
Can you Index-Match referencing multiple sheets?
Hi! I am a newbie to Smartsheet and jumping in head first. I am trying to use Index-Match to bring in information to a master sheet, but I need the function to look at multiple reference sheets. Master Sheet Highlighted in pink are the columns I am referring to. I would like the User to manually input a number into the…
-
Report Filter - data from 2 sheets
Need help! I have a sheet that references data associated with a Week #. I need to filter this list for a report based on date. I created a 2nd sheet to simply show the dates associated with the week#. How can I in the report filter to show data for the week associated with the week# that starts in next 7 days? The sheet…
-
Using COUNTIFS with CONTAINS
I am trying to count the number of rows whose tier contain "Plus" and are within a specified date range. I have this formula which works for a specific tier (not using "contains"): This formula works: =COUNTIFS({Tier}, "Experiencia", {Original Launch Date}, AND(@cell >= DATE(2022, 12, 1), @cell <= DATE(2022, 12, 31))) This…
-
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…