-
Need help with Date Calculation
I am just learning about date formulas in Smartsheet and having trouble - Need help with "ExpirationDate", 1st Contact, and 2nd Contact formulas
-
Countifs formula for tickets created within a month
Hello, I have a situation where I am trying to count tickets that were closed within the same month they were opened. I have a status column, a created date (automated from the system) and a completion date. I am using the formula below but the system is giving me a value that I know it is not right. I am thinking I need…
-
SUM not totaling negative numbers correctly
I need to use a formula to get the totals for 4 cells that contain formulas. I have used the SUM or AVG function on this sheet for the same purpose and it has worked fine. Now it's not working and I'm wondering if it's because I'm trying to add negative numbers. Anyone know how to correct the total cell formula so it…
-
Counting Multi-Select Column Criteria Formula
God Day Smartsheet Community: I am Trying Count My Risk in my RAID Log. However The RAID ID is a Multi-Select Dropdown. My Formula is Returning 0 Risk when there should be at least 1 Based on the Rest of The Formula There is 1 Risk in my Source Sheet that Meets The Criteria of CPC, Open RAID Status, and Contains R in The…
-
Manual Override of Formula Index/Match for Out of Office with Column Formula
Hi All, I have an index/match pulling in data relevant to a Business Unit from off sheet. I need to get it so that I can override this formula data to be blank/allow entering of a different email address by the sheet user. What I have setup already (working with Column formula): 1) User inputs Business Unit (BU) 2) BU auto…
-
Progress bar
Hello, We typically use % complete but I've been asked about using the progress bar rather than % complete. I have my formulas below working however, if you have tips on how to shorten them, simplify them, please let me know - Thanks! I'd like the project managers to set the State (drop down symbols- RYGB) and the %…
-
Creating a formula for sub-total based on SOW#
Hello, I need some assistance with a formula. I have the following sheet with an 'Original SOW#' & 'Approved Change Order Amount' columns. I would like to sum up the Approved Change order Amount by Original SOW# AND bring this subtotal to a different sheet. Example, for SOW# 012, the sub-total should be $117,000. Then, I…
-
Tracking Project Status Success Rate
Hi Smartsheet Comm, I have a column with a drop down list of 5 choices of project status (Under Development, Proposal, Rejected, Withdrawn, Contract Won). I've used an automation to copy the row to a new sheet whenever the project status changes, but I'm having difficulty in taking this to the next level and measuring the…
-
Overall RYG Health Formula Based on Other Combined RYG Columns
Smartsheet Community: Does Anyone Have a RYG Formula that Looks at 3 Other RYG Columns to get the Over Health I Could Leverage? For Example: Scenario 1: If All 3 Columns are Green, then Overall Health is Green Scenario 2: If All 3 Columns are Red, Then Overall Health Red Scenario 3: If All 3 Columns are Yellow, Then…
-
Issues in using IF & AND formula in counting room nights
Hi there. I have a rooming list for an event in which I am trying to work out a formula below to count the number of rooms required per night, based on hotel check-in and check-out dates. I tried the below formula to return with 1s. =IF(AND([Hotel Check-in Date]@row <= [28/01/2023]$1, [Hotel Check-Out Date]@row >…
