-
Counting event between 2 dates
Hi, I would like to know on my sheet summary, how many clients got registered between two dates, ex: between November 1rst and November 30th. My dates are entered in this format DD-MM-YYYY. Thank you for your help
-
locking row to the top
I have a sheet that gets filled with data from a form, is there a way I can lock the top row so when the form is filled the new row appears below the top row. I have the row locked but new rows from the form always appear above it. Just having the row appear at the bottom wont work for me as I want formulas in the top…
-
Using COUNTIFS with CONTAINS
Hello, I have a contact column where some rows have more than one person assigned to a task. I want to count the number of tasks assigned to any given individual. This is the formula that I have created to do this: =COUNTIF(CONTAINS("Bernie Sanders", [Assigned]:[Assigned]), "True") The return value that I get is "0," which…
-
If Then with a Index Match
Hi, I'm having an issue where I cant put an index match as a result of an if statement. when I just have the index match in the cell, it does the action, but when i have the if then statement, it says the invalid operation. Am I just missing something in the formula? I am planning on making this a pretty long chain of if…
-
Manage multiple values in a cell from a dropdown list
Good morning, I am facing an issue on my smartsheet, i have a column (dropdown list type) that allowed multiple values per cells and i am trying to manage these different values in order to concatenate them the way i want in another cell. Does anybody knows the way to pick a single value from all of them or even the way…
-
Formula help
Hello, I'm new to formulas in Smartsheet and I'm having difficulty adapting from Excel's formulas. Budget Formula help with: IF the (spend category) column on the main budget sheet matches the (spend category) on the January sheet then return the (actual amount) in the (January) column on the main budget sheet.
-
Formula to Flag Tasks that are on the Critical and / or Driving Path
I'm aware how to highlight these in the Gantt, but if I wanted a checkbox to flag which tasks are on the CP and which ones are on the DP, anyone have an idea how to do that?
-
Can I use a formula to create a new line at the beginning of a field? CHAR(10) doesn't do it
=" " + CHAR(10) + CHAR(10) + "joes" + CHAR(10) + CHAR(10) + "joe" does this: ="." + CHAR(10) + CHAR(10) + "joes" + CHAR(10) + CHAR(10) + "joe" does this: I need to accomplish this second outcome, without the dot. The reason is that I have some formulas that combine fields with line breaks in between each field, and the…
-
Incorporating ISDATE into Formula to average the time between various dates if conditions are met
I have a formula for calculation of a row by row average of review cycles, where each row can have 3 review cycles. I'm trying to figure out how to incorporate the "ISDATE" Function into this formula such that if one of the review cycles is unnecessary and a user enters "N/A" the formula will still calculate correctly.…
-
Trying to JOIN/COLLECT across several multi-select columns in a different sheet
I've spent a fair bit of time trying to figure this out with no luck. I suspect at least part of it can't be done with multi-select columns but I'm sure some of you good people can school me on this. I'm trying to join the values of 6 multi-select columns on one sheet into a single column on a separate sheet. Cells can be…