-
How to count number of projects in 2023 by current status
Hi, I created a Metrics sheet that feeds a dashboard last year that counted the status of a variety of items and it worked great when there was just one year. This year, I now need to only count the items that are for 2023. In the main sheet, I have a column that has the year in a string format (it's a formula…
-
Formula not working anymore
Hi, I have this formula that worked in the past and now is not working, I don't know since when. =16 - (SUMIFS({Tems en Maladie}; {Employee name}; [Employee name]@row; {Date}; YEAR(@cell) = YEAR(TODAY()))) Now the cell shows #INVALID DATA TYPE How can this happens?
-
Stumped and Looking for Help
Help! I can't get this formula to work correctly. It works fine when the helper column is "1" but when its "0" it gives me a blank cell in the "Project Timing Status"cell. It should read "Pushed". What am I doing wrong?? Thanks in advance for any advice you can provide.
-
Keyboard shortcut to delete a row
Hi Everyone, I am used to working in excel and using keyboard shortcuts to navigate my sheets without having to use a mouse. Is there a keyboard shortcut to delete a row? if not can how do I let the product team know to add this to the development queue? thanks!
-
Incorrect Argument Set Error
Can anyone help with the below? If I input the formulas into Separate rows they all work fine. When combined into 1 row I get an Incorrect argument set error =IF([% Complete]@row = 1, "Green", IF(AND([Actual Start]@row = "", [Start Date]@row < TODAY(-5)), "Red", "Gray", IF([Actual Start]@row > [Start Date]@row, "Red",…
-
How to calculate positive & negative time
Good day everyone, I've designed a smartsheet for an airline operation and dealing with standard departure / arrival times versus estimated departure / arrival times. I have this formula that works great: =IF([ETA/ATA (LT)]@row <> "", ((VALUE(LEFT([ETA/ATA (LT)]@row, 2)) + IF([ETA/ATA (LT)]@row < [STA (LT)]@row, 24)) +…
-
Data Shuttle - all rows get deleted?
Hi all, I've got several excel files that I am trying to consolidate within Smartsheets. Unfortunately, the excel files change from month to month and I thought it would be good to delete line items from the target Smartsheet that are no longer in the source sheets. However, if I select all three options as below, what…
-
Trying to pull data from a cell if all its descendants are 'not blank'
Hi, Someone here helped us with a formula a while ago but we've come up against certain scenarios where it isn't working and could use some help to modify it. Here is the spreadsheet we are working with: The formula in the cell that I've circled pink is: =IF(COUNTIFS(DESCENDANTS([Invoiced Amount (Less GST/HST)]@row), @cell…
-
Formula help - Getting Unparseable!
In my formula, I am taking data from three columns 1)if my Room Type field = King and it falls in between the 2) hotel check-in and 3) hotel check-out date to give me a 1. I need to know how many Queen Rooms I need on any given day. Here is my formula: =([# of King Rooms Needed]@row = "King") * IF(F(AND(DATE(2023, 7, 29)…
-
COUNTIFS + IFERROR + MATCH?
Good afternoon, I have two sheets I am working with, referenced here as Sheet A and Sheet B. Both sheets contain an identical column, which I will call "ID Number". Sheet A contains another column, which I will call "ID Location". On Sheet A, there may be multiple rows with the same "ID Number", as they can be in multiple…