-
#Invalid Operation when attempting to find difference between two cells
Good afternoon! I am trying to get the difference between two cells (both from formulas) but get the "Invalid Operation" instead. I know this is simple and I'm overlooking something!
-
Array formulas
Hi, I was looking for using array formula functionality in smart sheet. I need this because i saw that like this i can full fill what i need. Any case, could you please mention if is a way to use array or other solutions in order to perform: - I want smart sheet to show me in a column date, the first date, closest that…
-
Concatenate text and currency issue
I am trying to concatenate or JOIN a column with currency and standard text - I can do this, however it doesn't show zeros on the currency, for example; instead of £2.00 I get £2 Can anyone help as to how I can get the formula to exactly replicate the currency value. Obviously adding a zero to every result isn't an option…
-
How to calculate number of text occurrences in column and return a number
I am trying to calculate when a Y appears in a specific column and return the number 2 when this occurs and 0 when is N, any ideas on best formula have been pulling hair out!! Thanks
-
Having trouble using VLOOKUP formula in my Smartsheet
Hello Community, I have been trying to use VLOOKUP to cross check a screening date to what screening number was performed on that date, or within the date range; though I haven't been able to make it work! Please can you help me with what I need to do to make it work. My formula is: =VLOOKUP([Date of stock switchover]25,…
-
Lookup To Return Multiple Results
Hi - I've done some research, but am struggling to find the best solution on this one. I am trying to do a lookup from one sheet to another based on a Unique ID. A VLOOKUP returns only one result, but I'd like to return all of them back to one cell in the other sheet. It seems like some combination of COLLECT, JOIN, etc.…
-
COUNTIF function for the checkbox?
Hello all! I want to create a graph with checkboxes. Lets say I have some departments of: Governance / PMO M&A Communication Commercial and in my sheets I also have a checkbox column which is ticked based on whether they need support on a project. I am trying to figure out how to use the countif function to count the…
-
How to count tasks occurring over a date range based on another column parameter selected
Trying to set up a formula to count tasks happening during a date range based on another cell drop down ie approved, not approved etc, any ideas? Thanks
-
Count file names only
I'm trying to create a unique ID for documents. I would like to generate a unique number for each Category (in "Abv") but I'm struggling to not count the parent rows. My current formula is: =SUM(COUNTIFS(Auto:Auto, <Auto@row, Abr:Abr, Abr@row) + COUNTIFS(Auto:Auto, Auto@row, Abr:Abr, Abr@row)) The formula abode had been in…
-
Why are my sumif values different on my "sheet summary" than they are on my separate sheet?
I have a sumif formula in my "sheet summary" that is giving me a correct value when summing my values on that sheet. My formula is: =SUMIF([Project Status]:[Project Status], "Active /WON", [Project $ Value]:[Project $ Value]) When I use the sumif formula on a separate sheet referencing the same data I am getting a much…