-
Convert fractions to decimals
I'm looking for a formula that I can use to convert (15 1/4 to 15.25) or (15 1/16 to 15.0625)
-
Possible Solutions, anyone?
Hi Smarties, One of the users I am working with right now would like to have the following built in Smartsheet. Request Intake sheet > requester to enter the Task Type, Date Submitted and desired date for completion, and I will build a formula to estimate start date and estimate end date. I have managed to build a formula…
-
How to stop a formula once a date has passed.
I have this formula: =IF([Hidden Team:]@row = "ALBQ", {[Rosters] 2021 CC Team Range 1}) The info my formula is pulling is date sensitive, and the info will change over time. Once a date in the row is reached I do not want the formula to perform anymore. I need to freeze the value that was returned once a date in the row is…
-
Why isn't my % Complete count if working
I can't get my CountIf formula to work completely on the % Complete Column of my project sheet: =COUNTIF([% Complete]:[% Complete], =100) It does return return 3 when I have the criterion set to =0. It returns 0 when the criterion is set to =3 or =100. I have tried "3%" and "100%" as well but it still comes back 0. I don't…
-
Status Automation Based on the Number Of Check Boxes
Good Day Smartsheet Community: I need a little help on Adding to My Formula Below: =IF(COUNTIF(TS3:[Contractor Access]3, =0), "Not Started", "In Progress" I would like to Add that If All Checkboxes are Checked then Complete If 1 Checkbox is Checked then In Progress If 0 Checkboxes then Not Started Thanks
-
COUNTIFS with date range as criteria.
I am trying to use the COUNTIFS formula with a date range. Here is what I have: 2 sheets Attainment sheet (This is where the formula is) Schedule sheet On the Schedule sheet, I am looking at 2 columns Schedule Range 2 = Team column Schedule Range 3 = Service Date column I am trying to see if the Team column contains a…
-
How to automatically assign a Symbol when comparing two date columns?
This is what I got. =IF([Launch Date]@row >= [Estimated Delivery Date]@row, "Green", IF([Launch Date]@row < [Estimated Delivery Date]@row, "Red")) However, I want "Yellow" to be assigned when the [Estimated Delivery Date] is less than 30 days from the [Launch Date]. Appreciate the insight.
-
Determine if a Date is equal to or greater than 3 months ago
Looking for syntax help. I have columns (This Month, Last Month and Previous Month) to support some dashboard reporting IF statements. I am now looking to add a column called ">=3months" and I am unsure of the syntax. The syntax below is what I am using to determine Last Month: =IF(AND(MONTH([Record Date]@row) =…
-
Sum of True/False (1/0)
Hi, I am using this formula to search a multi-select column for if that column contains "IDS". =IF(CONTAINS("IDS", [Define Resource Needs]@row:[Define Resource Needs]@row), "1", "0") It is returning the 0 or 1 to me just fine - but what I want is a sum of the instances of "1". This will give me a count of how many times in…
-
SUMIFS & Specific Text/Quarter Requirement
I am trying to write a formula for a dashboard that sums the amount of money we spend a quarter based on a specific text. This is what I have so far and I'm getting "Invalid Operation". =SUMIFS{Log Sheet Range 2}, {Log Sheet Range 1}, CONTAINS("Pens", @cell), AND(({Log Sheet Range 7} = "Q2"))) Log Sheet Range 2 is the…