-
Date format in automated emails
Hi there, I've set up an automation on a sheet and noticed that the dates in the automated emails are in the incorrect format, despite me setting my regional preference in the settings. I have the dates set up in my settings for Brazilian format (i.e. DD/MM/YY) and this is how it shows in the Smartsheet itself. However, I…
-
Getting #Invalid Operation
I have the following formula and am getting an #Invalid Operation message. I only get the error though when it returns "Red". The column is defined as a Date and is restricted to dates only. I think it has to do with the TODAY() part of the function. =IF(AND([Due Date]@row < TODAY(), [Due Date]@row > " "), "Red", "Green")…
-
Report does not display sheet dates or dropdown menu items
Hi there, I used the "Project Management Office" template to set up different projects and then a report that pulls the information from all the projects into a central report document. I have noted that if you have drop-down options in your original sheets, or dates, these are not displaying in the report. How do I…
-
Return different value based on date
Hi, I'm trying to write a formula to return different values based on the reference date ([Next Calibration/PM Date]@row) compared to today's date. I want the equation to: If the cell is blank, return as "Pending", If the date is < = today, return as "Overdue", If the date is > today, return as "Current", If the date is…
-
"Record A Date" automation not working
I'm trying to set up a multitude of automations where, when the status of an item is clicked as "complete" it will auto-populate the date into a date column. I set up an automation for this function but when I go back into the sheet to test the function, it's not working. I previously set up a conditional format that…
-
If formula with Date and Time
Hi. I created the formula below to close a dynamic view on Oct.30th. =IF(TODAY() <= DATE(2024, 10, 30), "Open View", "Lock View") How do I adjust that formula so that the view can be locked at 5pm on that day?
-
Counting Days with plus or minus options
I know, I know… use =Networkdays([start date]1, [end date]1) HOWever, I am trying to track the performance of when a job is completed according to its due date. I found adding a -1 to to stop the inclusiveness of the calculation, whereas I can get a job completed on 10/5 that was due 10/6 to show 1 day using…
-
Formula for "Due date = 3 business days before Deploy date?"
Hi, I would like to build a formula with the following logic: "Due Date = 3 BUSINESS DAYS prior to Deploy Date." Building a "3 DAYS prior formula is simple enough, but I'm wondering if anyone has solved for logic that can only offer a day that's Monday thru Friday. I appreciate any advice! -Adam
-
Why is the Date function not working?
I want to calculate the first day of a month based on the "created date" column. I tried using Year Function to get the year, then the Month to get the month and last column calculates =Date(([Yearcolumn]@row),([Monthcolumn]@row),1) Yet I get the #INVALID COLUMN VALUE year and month formulas are set on number format What I…
-
SUMIFS Delivery Date >= Inventory Date
I'm attempting to write a SUMIFS formula where one of the criterion is to compare one date to another. It is returning 0 when it should return 1830. =SUMIFS({PURCHASING QTY EA}, {SHIP TO PLANT}, "HUBER HEIGHTS", {CONDUIT PURCHASING JDE CODE}, "RPVC0412200", {CONDUIT DELIVERY DATE}, >={CONDUIT INVENTORY DATE}, {CONDUIT…