-
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…
-
SUMIFS and CONTAINS Formula
I am try to sum the total weight of a column on a different sheet if the name contains certain text and will be released on a certain date. I am using the below formula but getting #INCORRECT =SUMIFS({Estimated Weights Range EST Weight}, CONTAINS("C-Vibez", {Estimated Weights Strain Name}), {Estimated Weights Est Release…
-
How to use any date within a date range as formula criteria?
O, great wizards of the Smartsheet community, hoping you can help me cast a formula spell. Trying to create a formula to flag if a resource is overallocated in a master sheet that tracks resources across multiple projects. NOT using either the legacy resource management or RM by SS, just core Sheet functionality. I managed…
-
Project status synchronization between 2 sheets
I have 2 sheets (2 project trackers) and need to present the status in a "master" tracker based on a data from the "slave" one. The problem is that in the slave there could be couple (even 20) rows that are connected to the one project in the master file. They are connected via Project Name column. I need to somehow merge…
