-
using NOT
Hello, I am trying to write a formula to identify open deviations that are in another sheet. The column that I am referencing {Deviation Tracker Range 3} has multiple options for the stage it is in but I only want to collect what is in {Deviation Tracker Range 1} if the cell does not contain "Closed". (for reference…
-
Formula help to calculate sum of items across smartsheets
Hi Smartsheets community, I've recently created a Smartsheet with all the different types of meetings and then I have separate columns for the count of meetings attended, missed and chaired. In a separate worksheet, I wanted to create a summary (not using summary report) but it's only counting the number of rows created…
-
Countifs using multiple columns + if date is in the last 7 days
Hi all, I have two different formulas that I want to combine. They work separately, but not combined. Formula one =COUNTIFS([Roof AHU 1&2 Base Build Supply Fan]:[Roof Lights], "Yellow") Formula two =COUNTIF([Date of Plant Check]:[Date of Plant Check], >TODAY(-7)) I want my formula to pick up where the symbol is yellow but…
-
Can anybody explain this seemingly impossible formula result
https://us.v-cdn.net/6031209/uploads/R00HCP77EPPO/formula.txt We have this formula in the [Task Status] column of every one of our 82 production sheets (as a column formula). See the attached .txt file for a pretty printed version of the formula. =IF([DTM?]@row, IF( OR( ISBLANK([Start Date]@row), ISBLANK([End Date]@row),…
-
How to create a time stamped column with the date
How do I create a time stamp column to auto populate the date and time of when a cell changed from blank to a value? The workflow to fill in a date does not provide the time and I cannot figure out a formula that would capture both date and time?
-
Missing formula function. Please help determine!
Good morning Smartsheet Community. Hope you all are well. I'm looking for help to find the proper function to help me achieve what I'm trying to do. I have three columns seen in the screen shot below, Rough In Date, Install Date and Tech Date. I currently have the following formula in the Tech Date Column.…
-
Sheet Summary Formula Help
Hello, I am trying to pull some numbers from a list of past projects that have completed from certain years. The formula i have will pull from the current year. I need to know how to pull from 2024 and then in the future I will pull from 2025, etc. I have tried changing some parts, but it will not work. Thanks!…
-
Question about Templates and Formula References
Hi, I am creating a template of a "Cost Estimator" which will be created into a new sheet each time I have a new project. The Cost Estimator sheet will link to a master Project List using the Project ID and the Project Name. What I am attempting to do is create a Cost Estimator "Totals" sheet which will have a row linked…
-
CountIf Formula Help across sheets
I have used this formula in previous sheets but seem to be having some difficulties in pulling the correct data in this new sheet. Current Formula: =COUNTIFS({MazdaPortfolioSummary.EnrollmentRecd}, IFERROR(YEAR(@cell ), 0) > 2015, {MazdaPortfolioSummary.Region}, Midwest1) We are setting up control center and only have one…
-
Using If/or/and to change date based on different drop downs and checkmark selections
Hi all, Adding on to an existing formula to automatically add a number of days depending if a column is checked or not. The bone column is either "NA" or various types of bones which populates the final date in the QC column based what is selected. I'm trying to add if the Timeline extension box is checked, it will add the…