-
Error when refrencing a date column in formula
I am attempting to change the Fabric status column based off the dates in Fabric A,B,and C received date columns. I want to return a value of Received in the helper column if there is a date in Fabric A received date, unless 2nd fabric required is checked, then Return the value of Received when there is a date in both A…
-
Dynamic Date Calculations
We have different project types, and each project type has a different number of days is needed to complete a task. We have a sheet of about 30 rows that defines based on what project type, how many days it takes to complete the task. I want to make a date column to say "this is when this task is due" but I'm not sure if…
-
Wrong date pasted when copying "Created date" to "Date" field in Report
Scenario: A sheet used to track customer request fulfillment has both a manually entered "Date" field and an automated "Created date" field. The idea being if needed, you could enter records after the fact and still track the correct date for reporting. The data needs cleaning. I created a report for staff to easily see…
-
Dates are formatting in 2 different ways on the same sheet
Is this a Smartsheets bug? My formula is simply concatenating the date with the time. This seems to happen randomly when smartsheets updates itself, and it fixes itself only when I re-save the sheet. Our Windows OS date settings are set to American format mm/dd/yyyy, but our smartsheets are set as dd/mm/yy Is there any way…
-
Question on DATE(x) function referencing another location for date instead
Question: I wanted to see if there is a possibility to reference the begin date to end date from another cell instead of inside the formula. MY attempts to use a reference to another location has failed. For Example: DATE([8]1) instead of DATE(2024, 12, 31) Syntax I am using. =SUMIFS({GL Datasheet_Amount}, {GL…
-
Allow Grouping of Dates by Month/Year Year in Pivot Table App
I know we can achieve this with helper columns in sheets, but I think it would still be a game changer if we could design Pivot tables that allowed grouping/summarising of dates by Month/Year without needing to edit all the sheets to include a helper column. If we could do these sorts of date logics directly in the Pivot…
-
auto-populate date formula when column is checked
Hi All! I am looking for a way to add the date to a column when a check is placed in another column. I would want the date the check mark was added to the column. Any advice for the formula? Thanks kindly!
-
How to add varying months to varying dates?
I am really having trouble getting a formula to work here. I've gone through a number of support articles, but I'm just missing something. I want a formula that looks at Date Contract Executed and it adds Months Until Expiration to produce a new Date of Expiration. I've got my date columns as dates and the middle column as…
-
COUNTIF formula between date range
I'm trying to do a countif formula between a specific range of years, while referencing from an alternate sheet. This is the sheet with all my data (of course, just a small example) And this is the range within which I'm trying to work. For 1976-2000, the formula I have is =COUNTIFS({Game Design Range 2}, >=1976), but…
-
Formula that returns a value equal to every other day
Date formulas are the most challenging for me. The requirement is to provide a visual calendar that will trigger the quality audit team to complete the audits expected for the current business day. The sheet has three frequency options: Daily, every other day, and weekly. I am struggling to determine the formula for every…