-
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…
-
COUNTIFS formula for criteria in two columns in another sheet not working
I am counting how many ads are live out of how many total and I'm unable to get the COUNTIFS formula to work. The cell should reference another sheet and count how many ads are live in each category. The formula I'm using is coming up unparesable even though I referenced Smartsheet's many help pages on this topic. What am…
-
Countif formula using a date range
Hi, I'm trying to count the number of rows within a specific date range and can't make this formula work: =COUNTIFS({Date to Deactivate}@row, {Date to Deactivate}@cell >= DATE(2022,04,01), @cell <= DATE(2022,04,30)) Thanks for your help!
