-
What formula will identify duplicates in a column and only keep the most recent row?
Hi there! Our staff fill out an "availability" form which populates a sheet with their availability for the week. I'm trying to create a formula for this sheet that will identify when a person has submitted their updated availability, and remove/hide their previous submissions. I assume the way to do this would be…
-
Date Comparison Unexpected result
Option 1: =IF(([Last_Updated_Date]@row - $[Last_Updated_Date]$1) < 0, "Up to date", "Please Update Before Proceeding") Option 2: =IF([Last_Updated_Date]@row < $[Last_Updated_Date]$1, "Up to date", "Please Update Before Proceeding") I am writing the result in a column name Template_Updated which is Text/Number Column data…
-
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…
