-
Bring data from another sheet (Row data)
Great community! I need help to bring data from another sheet. If data is input vertically, then I can use countifs or sumifs, etc... but it is horizontally input. In the picture, I want to bring the number 100 (Purple) to Green square from the Sheet 2 to Sheet 1 , When customer name, product name , Year and Month is same…
-
How to use IF formula with DATA from another sheet
Hello, fantastic community; I want to build a formula that If a cell = XXX, then it will work with me the value of another sheet- can you guys help me? formula =if(coachname=coachname in another sheet, cell b of that other sheet info is true)
-
formula to automate a status not working
Hello, I'm working on a risk assessment matrix with an Impact column with 5 options (e.g. Insignificant, Minor, Moderate, Major and Extreme) and a Likelihood column with 5 options (e.g. Rare, Unlikely, Possible, Likely, Almost certain). When selecting an option in the Impact column and then one in the Likelihood one, it…
-
COUNTIF Formula to Count Months Between Dates
I am new Smartsheet user and I'm working to convert some Excel files we use over to Smartsheet. I need to count the number of months an employee has been employed based on their Hire Date but if they have a Term Date the count should stop at that date. This is the Excel formula I am replacing (I didn't write this):…
-
COUNTIFS formula troubleshooting - multiple criteria and checkboxes
Hi SmartSheets Community, I'm new to Smartsheet (but know some basic Excel), but am getting stumped on this formula. Can you advise what I'm doing wrong? I'm trying to create a formula that 1) counts either Red or Blue cells in another spreadsheet column (Other Sheet Range 1), and then 2) counts a checkmark (or no check…
-
Pass promised date
how to write pass promised date on a project =IF(OR([Overall Project Status]@row = "Past Due", [Promised Completion Date]4 >= TODAY(), "Yes", IF([Overall Project Status]@row = "Complete", "No"))) It says incorrect argument
-
countif
Hi, I would like to count the number of ">3 hours saved" using the countif function. However, it is not working. I am writing the formula as follows: =countif(range, ">3 hours saved") the same issue with "<1 hour saved". Apparently adding the < or > signs is affecting the formula. Any suggestions please? I should mention I…
-
countif with > or < signs
Hi, I would like to count the number of ">3 hours saved" using the countif function. However, it is not working. I am writing the formula as follows: =countif(range, ">3 hours saved") the same issue with "<1 hour saved". Apparently adding the < or > signs is affecting the formula. Any suggestions please? I should mention I…
-
#INVALID OPERATION Error
I've been getting an #INVALID OPERATION Error for the last several hours. The error was coming up in a different formula in a different column (that was also attempting to multiply a number times the Tax Rate), and as I stripped out criteria, it became apparent that Tax Rate is causing the error. Below is a simplified…
-
Regarding Index/Match function
I have a work sheet that uses Index/Match formula. The reference sheet is separate from the worksheet. Question - If I share both sheets with a coworker and they save both on their computer. Will the sheet be able to find the reference sheet without any intervention (i.e. redoing the formula) Thanks