-
How can I add days to a date field within a logic formula to output a true/false value for a chkbox?
My objective is to create a new column where a box is checked once the row meets desired criteria. The checkbox will help me filter-out rows that will be synced via a Salesforce Connector workflow. The logic criteria is as follows: "Overall Status" = Blue (complete)….and…. "Working Launch" Date + 7 Days </= Today's date…
-
Time and Date calculation
Is there a way to show how many hours passed from the time the form was submitted/created to the running/current time and date? I am trying to show the running hours lapsed while the entry submitted is still in the "Pending Status" I have the following column available I wanted to show the current duration in hours that…
-
How to count several non-blank rows based on specific criteria across two sheets
Hi Community! I have two different grid sheets within smarthseet with the following information: In sheet 1 I have several products that need a certain number of photography shots and being delivered in different channels. Each row has a due date. In sheet 2 I want to find a formula that would give me the numbers in blue.…
-
Why didn't my original CountIF formula work?
I am trying to count the number of projects that began since Jan 1, 2024. I typed in the formula =COUNTIF([Start Date]:[Start Date], ">= Jan 1, 2024"). Basically I wanted to count the number of projects with a start date that were equal to Jan 1, 2024 or greater. However that formula gave the blatantly incorrect answer.…
-
Why is 'DAY' Value from a Date being populated incorrectly?
I have a 'Formatted Date' column with a column formula (below) that formats the date from the row's date timestamp, which I renamed to 'Training Completion Date', into DD-MMM-YYYY format. All rows but one is getting the correct day from the DATE. I cannot figure out why 10/08/24 returns 9-Oct-2024. Curious to know if…
-
Modify Date Format in Dynamic View
Would love the ability to choose a date format in dynamic view. We share our smartsheet with international partners, so the ability to set the date format to unambiguous dating (dd/mmm/yyyy) is crucial.
-
Dates & Formulas
Hi, I'm trying to create a formula to work out the difference in days between 2 cells, both of which have values derived from different column formulas. The output column is giving me #Invalid Data Type. Any thoughts as to how I fix the issue? Column37: =NETDAYS([Column31]@row, [Column34]@row)
-
Form Submission Date Requirements
Is there a way to set a date requirement for a form submission on a Smartsheet? Meaning, I have a Smartsheet that is for event request. There is a form that auto populates this Smartsheet. I want to set it where the submission date must be at least 2 weeks (14 days) prior to the requested event date on the form. Is this…
-
Different Dates on the one sheet
I am in Victoria, Australia and I am using a form to populate a sheet. I want to automatically populate the Inspection Date to be the date the row was created. I am using the formula =created@row The Created date, being the system generated date is correct, but as you can see the Inspection date using the above formula is…
-
Help with ISBLANK on column formula
I am stuck getting this to work and have been trying both ISERROR and ISBLANK but keep getting an UNPARSEABLE error. Here is the overview of what I need to do: First, I have a column [Cumulative Delay for Start Date] that increments based on other values for a row. The second column is the base starting date [CALC DATE]…
