Formulas
Discussion List
- HI, i'm new to spreadsheet, currently i'm on trial version (30days Trial) planning to buy after using it like one week, yesterday i've noticed i cannot convert text/number column into formula column i…
- Another day, another question to the Community...! I'm trying to get a count of all jobs starting in each month. My formula is giving me an #INVALID OPERATION error though. =COUNTIFS({Start Date} >= (…
- So, I am trying to create something similar to what I have in Excel in Smartsheet where it looks to match two things and if both are present it returns true, if not then false. The problem is it is re…
- Not sure if it is possible, I have tried some basic if statements but not getting anywhere. Looking for some help please, trying to get an if statement to work in the Validation Status column, where i…
- I have a sheet that I am trying to inform team members when their license expires and I am wanting a formula that looks at one sheet, if the name is there it return the corresponding value. I can get …
- I'm using Sheet Summaries to total up information in a large sheet. This sheet also uses formulas to pull information from other sheets. I receive a #NO MATCH error when attempting to use a COUNTIF fo…
- I am trying to write a formula based on two sheets. One sheet, Team Members, that has the following columns: Column 1 - Region Column 2 - Industry Column 3 - Contact The other sheet has many columns, …
- I would like to locate duplicates in my sheet using the name column and email column. Just starting with the name column gets me nowhere. I keep getting #UNPARSEABLE. I am using =IF(COUNTIF(Client Nam…
- Hello, I am expecting this formula to count the number of cells in the "FND Prepare" column that have a certain name in them, where the cell on the same row in "Prepare Status" is not green. =COUNTIFS…
- Hello all, I'm attempting to create several self-updating sheets fed by a manually updated database sheet. The goal is that it will feed into the multiple other sheets so that we can then give access …