-
Is it possible to add weightage in Smartsheet?
Team, As part of my requirement, under my Survey, i have questions with list of choices. So i would like to pre-configure the weightage to these choices so that, once the end user selects a value, it should automatically populate the weightage in another table. Which should be later used for reporting purpose (if possible…
-
CountIF not working
Hi i am trying to count all the the number 4s and 5s wtihin a column. I am using this formula =COUNTIF([Stage ID]:[Stage ID], =4) + =COUNTIF([Stage ID]:[Stage ID], =5) but it does not work. the column has many 1,2,3,4,5,6 and i just want to count the 4 and 5s. thanks for your help
-
Adding 1 month to another date
Hi, Does anyone have a formula to automatically calculate 1 month forward from a date in another cell? I have tried =MONTH(Due1,+1) but this returns #Date expected error. (Due1 is the column and cell i am trying to add the month to. The above would be perfect but also if there is a genius way of the above calculation only…
-
Help! COUNTIFS function with 3 criteria
Hi! I'm having trouble getting this COUNTIFS function to work, getting the error "incorrect argument set". What I have: =COUNTIFS([Due Date]20:[Due Date]3443, <=TODAY(-7), [Assigned To]17:[Assigned To]3440, <>"", [Task Completed On Time?]16:[Task Completed On Time?]3440, "Yes") What I want it to do: Count rows that meet 3…
-
Summary sheet count when filter on
Hi, I am currently using a summary sheet. I have used the following command in one of my fileds =COUNTIF([% Complete]:[% Complete], <0.99) But i want to count when one of the columns has a filter. This command still counts all even when i have the filter on / off. thanks for your help
-
"Equal" cells
Hello Community, I have a regular project plan with several tasks, milestones etc. I was thinking of tiding it up by creating a collapsible section in the very beginning which will contain only the milestones. My idea was to use the simple "=" function so what I did was to simply clink on the cell in the Milestones section…
-
How to automatically put formulas in the new rows that will come in from a form
Hi, so we have three sheets in the company, and one as a master sheet where it gathers all information from sheet 1,2,3. Everytime I will be inputting a new information on a form, the formula doesn't apply on that new row. is there a way I can automate this that if there is a new row, it will have the formula of the one…
-
Use IF/AND or INDEX/MATCH?
I have a sheet (top) where Site Code and Sub-GL are drop downs. There are hundreds of corresponding site/sub-GLs listed in my reference sheet (bottom). I am looking for the correct formula to return value of "2021 OP2 Total" when Site Code and Sub-GLs are selected match a line in the reference sheet. I can't seem to make a…
-
Calculate Variance in Days
I need to create a formula that calculates the total number of days an employee is in training. One cell in my sheet is the Training Start Date. One cell in my sheet is Today's Date I need this cell to calculate the number of days between these to days. I tried =NETDAYS(start_date, end_date) and it give me #UNPARSEABLE
-
How to calculate a COUNTIF when using a date 01/01/2020 month to date
Good Morning Everyone, I am trying to create a formula that pulls from a master spreadsheet that calculates the number returned based on a date from the data sheet. I have columns that indicate month to date, September, August, July, June, May, April, March.... =COUNTIFS({LPSC tickets Range 1}, "Production", {LPSC tickets…