-
Avg collect Error
Hello Community, I'm running into a bit of an issue. My previous worked fine for the year 2022 but now that we're in 2023 I need to adjust my formula to account for the year change. Below is the formula I had been using which has worked well in 2022. However, now that I'm attempting to collect the avg score from the same…
-
Index & Match formula
Hi Smarties, I have a question on Index and Match formula. I am using the Project Management Office template set from Smartsheet. Based on the Intake sheet, a new project is created, and a number will be auto-assigned (SM-004) I made a few changes by adding in Project Type between Project Name and Project Manager. In…
-
SUMIFS in Smartsheet
Hi all, I'm trying to use SUMIFS in Smartsheet to sum actual hours for individuals between two dates. I'm using two sheets, one is the front facing table and the other is the raw data. I've tried this forumla which worked in excel, but won't work in smartsheet? =SUMIFS(sum_range, individual_range, criteria1, date_range,…
-
I want to count how many cells have a date.
I am trying to find a way to count how many cells in my column have a date in it. I use the formula =COUNT([Target Launch Date]6:[Target Launch Date]24) but it always appears the error code #DATE EXPECTED. I tried the same formula on other columns with text and it works perfectly fine. I also tried =COUNTIF([Target Launch…
-
count number of rows with dates that fall between start and finish date which have box unchecked
I have a sheet which is referencing another sheet. We would like to count the number or rows which have a date (on the referencing sheet) that falls between the start & finish date but the checkbox (on the referencing sheet) is unchecked. I have the countifs formula for counting the number of rows between the date. But not…
-
Duration in hours formula returning #INVALID VALUE
Hello, trying to calculate the duration in hours between two dates, see below: But the formula returns #INVALID VALUE. After reading another help post, I have edited the column properties so that the data type is date, but doing so removed the time stamp and the formula still returms #INVALID VALUE. So now I have two…
-
Query String to populate form
I have a query string I am using to auto-populate a form. It works great until the cell has multiple values. Here is the query string: ="https://app.smartsheet.com/b/form/611a48e1b24d445eb48e373c9e06e1fd?Internal%20Course=" + SUBSTITUTE([Course Name]@row, " ", "%20") + "&Course%20Start%20Date=" + SUBSTITUTE(Date@row, " ",…
-
Salary Formula ( Calculation of Basic and commission)
Hi , I need formula for (Net Salary) col as follow : To Count the sum in Col (Basic Salary) Plus sum of 15% for amounts equal/less than 600 and sum of 25% for amounts more than 600) of the number in Col (Total Income) We Pay our Employee (ex. sales man) salary with compensation of basic salary PLUS markup commission as…
-
Calculation Formula /commission calculation
Hi , Please find attached I Need to create formula in Commission column as follow : If amount in Price Col has amount equal to 20.00 or less Than to input the amount 2.00 in commission col and if the amount is between 21.00 to 25.00 than to input amount 3.00 in commission col and if amount is between 26.00 to 30.00 than to…
-
Health Formula
I'm currently trying to create a formula that will allow me to update the health status of tasks using both the due date data and the status of the work. I've tried looking at other discussion forums, but using those formulas does not seem to be working for me as they are causing errors. Is there anyone out there that's…