-
Date minus # of days to get new date
I am trying to have the Drop Dead column subtract 42 days from the Final Confirmation Date. I have the Drop Dead column setup as a Date Column and have tried doing this formula, but am getting an "Invalid Operation" error. Can anyone tell me what I am doing wrong? And thanks in advance.
-
How to Format Salesforce Date in Smartsheet for 30-Day Archiving Automation
Hi there, I have a sheet that pulls in Department Events via Data Shuttle from Salesforce. The issue is that I want events to archive off the sheet after 30 days. However, the date format coming in looks like this: 2026-03-16T00:00:00. Smartsheet automation doesn’t recognize this format. I tried creating a helper column to…
-
MIN(COLLECT( function issues
I know I'm going to kick myself when this gets resolved, but I'm having a bit of a brain fart right now. I'm trying to get the lowest non-blank value in a particular range (columns A-E). [A]@row=18, [B]@row=16, [C]@row, [D]@row, & [E]@row are all blank. All five rows are products of column formulas. Basically, there are a…
-
Show Duplicates Based on Multiple Columns
Hi, I was looking for a solution to showing "Duplicate" if the combination of ColumnA @row and ColumnB@row of the same row appeared more than once. After taking bits of advice to similar problems in the community forum and reviewing the Smartsheet functions list, this formula solved my problem. I thought it would be worth…
-
Stacked IF Statement Using AND and OR
I'm trying to write a formula that evaluates three columns of dates and pulls in the value of a fourth column (MWh@row) if each of the first three column's dates have already occurred in the past or will happen before the end of this year, and I'm not having any success. I keep getting an "#INCORRECT ARGUMENT" error. Can…
-
COUNTIF by Month in Date
I've always struggled with calculating total count by Month; i can do it for every else but when you throw in dates, it throws me right off. Essentially what i am trying to do is calculate on another sheet the amount of travel done within the month of March This is the formula i am using, but it comes back with 0…
-
Formula working for one data value but not another
Hi Community, I have a sheet that contains, among others, columns titled "Priority" and "Contract ID". Multiple rows can have the same Contract ID and the same Priority. Priority values are 1-2-3 and restricted to dropdown list values only. To collect the number of unique Contract IDs that are Priority "1", I have this…
-
Need Help With Date Calculation Formula
Hello, I have 2 date columns. I put a test sheet together for a visual reference. The Date 2 column needs a formula to calculate whichever date 39-45 days out is a Friday. Any help would be greatly appreciated.
-
How to create a day countdown from starting date
I am looking to have my sheet track the number of days remaining after a beginning date entered in a column (labeled Conversion Date). I need to know how many days are left from a total of 90 days.
-
Merged: Elapsed days as Duration with Normal days or weeks as Lag
This discussion has been merged.