-
what is the correct syntax for CCOUNTIFS to only count items where a date is blank
For example I am counting all items with a Red Status using =COUNTIFS(Status:Status, "Red") However, I only want to count items Red if the Date Added Column is Blank.
-
Check if a date is within multiple ranges
Hi there, I'm trying to figure out whether I could write a formula to check if a given date is within multiple ranges. Concretely, I have two sheets: One where I book people's time to work on specific tasks Another where I keep track of people's holidays What I would like is to get an error message if I try to book Yann…
-
Convert text to date
Hi I have a column containing text, which contains a date in MM/DD/YY format, followed by a longer string of text. For example, one of the cells contains "07/26/22-G" I want to populate another column, with column type = date, with the date, so that I can order by date. I tried this using this formula =MID([Test1]@row, 1,…
-
Automatic Finish date and Finish time columns for a 3D Printer Sheet
Hello everyone, I am creating a sheet for my 3D Printer and I need some help as I am new in Smartsheet and in using functions. I want to make the "Finish Date" and "Finish Time" automatic, meaning once I input the Start date, start time and duration, the Finish date and finish time will automatically show when my 3d print…
-
Help with SUMIF Formula
Hey Community, I need some assistance with a SUMIF formula. I am trying to say, Multiply Column 1 by Column 2 IF Column 1 is greater than 1, if not, leave blank. I have tried several different ways but all keep coming back #UNPARSEABLE. Would appreciate some help with this. Thank you in advance!
-
JOIN using Children with Multi-Select Dropdown
Hi everyone, I have a column in which the user selects the countries impacted from a drop-down list. More than one country can be selected. Now, I want to reflect all those countries in the child rows back to the parent row. Easy enough, just use =JOIN(children()), right? However, if I do this, it joins the information in…
-
Comparing Columns to Identify Health
Hello, I'm really struggling here and I'm sure I can do something simple but I'm just not getting it. Here's my task: Identify if any of our projects, which happen to overlap sometimes, are installing same version of software. If they are not, I need to flag that. I'm currently using "Green" and "Red" traffic lights for…
-
Smartsheet count function
I'm using the count function to count how many times a initial appears in a line and its working great except it won't count a line that has multiple initials in it. Does anyone know how to get it to count that line?
-
IF (AND) formula help
I can't figure out what I am doing incorrectly with this one...It is coming back #UNPARSEABLE =IF([Column2]2 <= 49.9,) 1, IF(AND([Column2]2 <100, [Column2]2, >49.9), 0.9, IF(AND([Column2]2 < 150, [Column2]2 >99.9), 0.8, IF(AND([Column2]2 >149.9, [Column2]2 <=199.9), 0.7, IF([Column2]2 >200), 0.6))) For example if Column2 =…
-
Closest Date in the Past
Hi, I am currently building a ranking that I will display in a Dashboard. I need to grab data from another sheet that is the closest in the past to keep it up to date. Any suggestions for a formula?