-
Help with Determining if date@row occurred last month using multiple criteria.
Hi. I'm looking for some help with a formula. I'm using the following formula to identify if the date last touched occurred last month, which works perfectly, but it was not my formula (which is why I'm having problems)… =IFERROR(IF(AND(MONTH(TODAY()) = 1, YEAR(TODAY()) - YEAR([Last Touched]@row) = 1, (MONTH(TODAY()) -…
-
Formula Functions causing cell references limit error?
Hello, I'm trying to determine which FUNCTIONS I'm using in column formulas of a program schedule sheet that may be causing too many cell references so that I'm going over the limit of 25 million references (when I have around 3000-4000 rows). Most of my formulas just have @row formulas, but I don't know what some of these…
-
Formula Question - Integration Project Management Tracker
Hello, I am a project manager in the acquisition space and am creating a project tracker in SmartSheet. One column contains the days +/- from the close date that a task needs to start and another column that contains the days +/- from the close date that a task needs to end. How can I create a formula that will take the…
-
Install Comparison Actual to Projected
Good Morning Community. I wanted to ask a question as it pertains to a comparison. We have been asked to show a chart that displays installed, not installed and projected installed. The premise is that in our project we have specific dates that are targeted for installation but with everything in project management that…
-
Date Range and status formula
Hello, I have a metric sheet where I am trying to build a formula that references a date range column and status column of another sheet, but I keep getting "unparseable" or "incorrect argument". I have tried the following formulas: =COUNTIFS({Event Date},>=(2024, August, 1),{Event Date}, <(2025, August, 1),{Event…
-
Formula to combine data from another sheet
I just had surgery and I am trying to keep track of my medicine inventory. So I created an inventory log of my medicine and I have it split into 4 columns as I want to keep track of each medicine so that when I am running low I can ask for a refill. So I have two sheets. Medication Count Management Medication Management I…
-
I want the total count from 2 sheets from a column with multiple leads
When I created the first formula it worked, when I add the second one linked to another sheet I get the nested criteria error. Even when I remove the extra end parenthesis still an error. Separately these both work together it doesn't work
-
Setting checkbox as true based on conditions of multiple columns
Hi! I am trying to set a formula that will check a checkbox based on conditions of multiple columns. This is the formula that I am trying to use: =IF((COUNTIFS([PMO: Contract requirements review]24:[PMO: Is customer source inspection required?]24, "complete")+countifs([PMO: Contract requirements review]24:[PMO: Is customer…
-
Formula Creation & Random Changes
Hi All, I'm building a reference Sheet off of a 'Master' Smartsheet in order to create a Dashboard for some KPI type tracking. I'm pretty OK with formulas, the main ones I'm using here are simple =SUMIFS() and -COUNTIFS() Example: =SUMIFS({TYS Master Data - From SFDC Range 1}, {TYS Master Data - From SFDC Range 3},…
-
Conditions
How do I stop an email from being generated from a condition in one cell that is sent out after it passes a certain day? I want the emails to stop when a condition is met in a different cell.
