-
Formula to change text
Hello, How do you generate a formula to change the text within a cell. I want to have different text for different due dates such as if the due date is within 5 days, I want the "status" cell to say immediate, and if it is within 2 months, I want the status cell to say "short term", if it is within 4 months, I want the…
-
CountIf and Exclude Status
Hello! I am trying to count the number of requests types and exclude certain statuses. The current formula is: =COUNTIF({Request Tracker Range 4 - Request Type}, Category13). I want to display the current number of Client or Internal requests and omit Completed or Declined. Any suggestions are appreciated!
-
Formula that averages a column
HI Smartsheet community, I need a formula that averages one column (# of jobs) if a checkbox is checked. I think I need to use AVERAGEIF and ISBOOLEAN, but I can't get the syntax right. Help! -Bridget Sloane
-
How do I create a cross-sheet formula for a sum $ total within a date range
I'm trying to calculate the total spend for a customer based on a list of transactions in another sheet in a specific date range. The dates in the sheet I'm trying to reference are classified as dates in the column properties and appear as "1/30/19" for January 30, 2019. For example, in the sheet in which I'm attempting to…
-
Using Approvals with a formula cell
I am trying to use an approval request to change the value of a cell that contains a formula. The cell that has the formula is based on data in two other cells. For example, the other two cells can either be "Yes" or "N/A". If both of them are "N/A", then my approval cell automatically changes to "Yes" and it does not…
-
#Incorrect Argument??
I'm trying to build an IF statement that will change the value in a Status column. The Status column has three values in the dropdown (Not Started, In Progress, Complete). I would like to leverage two adjacent Date columns (Scan Started, Scan Completed) to auto-change the values in the Status column, but can't seem to get…
-
Adding Checkboxes
I am trying to created check point progress with check boxes and a visual aid. I created a If formula, but my progress is not adding up. I would like to know if anyone can help me with a better formula.
-
Help! Already reached Vlookups Max reference Cell count of 25,000
I need a solution to the vlookup max reference cell count of 25,000. I have a database that zapier loads data too from an application. The database consists of 134 columns, and will grow to an estimated 300+ row count. Which works out to 39900 cells, which is 14,900 cells over the limit. I use a summary sheet to gather…
-
RGYB Automation
I'm having issues with the following formula and I'm not sure why. Task Formula below: =IF(ISBLANK([Start Date]@row), "Blue", IF([Start Date]@row >= TODAY(), "Blue", IF(AND([At Risk]@row = 1, [End Date]@row <= TODAY()), "Red", IF(AND([End Date]@row <= TODAY(3), [% Complete]@row < 0.75), "Yellow", IF(AND([Start Date]@row <=…
-
Using IF with RYG formula
Hello I am trying to build a formula where: * If the "Date Entered" column is within 60 days, the "Req Health" stays Green * If it is 90 days or more, Req Health turns Yellow (I got this formula figured out) * 125 days or more, Req health turns Red. Sheet…