-
show only date vs date time using Concatenate formula
I am using the formula below to display 2 dates in a single cell but its displaying "date time - date time" vs just "date - date". In the original cells only the date displays (no time). Any suggestions on how to set the formula? =[Start Date]49 + "-" + [Actual End Date]49 currently shows 10/6/2020 8:00 AM-10/08/2020 4:59…
-
Add x months to a date
Hi All, I have being googling for an hour and haven't figured it out. I want to add a number of months to the date in column [inspection date]. The amount i will specify in column [inspection period]. That is to say that i end up with a date 6 months on from the inspection date. I can then create an automation that will…
-
Autocomplete date range
Hi All, This is likely something quite straight forward that I'm over looking, but hoping someone may be able to advise - Still relativly new to smartsheets. I have a smartsheet, in which each row reports based on week numbers, such as the below formula. =COUNTIFS({Enquiry Tracker (V1) Range 4}, <=DATE(2020, 9, 6),…
-
Unparseable error
I am getting the 'UNPARSEABLE' error on the following formula, any insight would be appreciated: =IF(MIN([FPFV (Updated)]1:[FPFV (Updated)]107)= [FPFV(Updated)]@row, (MAX([Actual Go Live Date]1:[Actual Go Live Date]107)+7), TODAY())
-
=IF statement not recognizing two cells as matched
Using this formula to check if two values in the same row match, and returning "Yes", "No", or "Hold" to display the associated symbols. =IF(ISBLANK([Column A]@row), "Hold", IF([Column A]@row = [Column B]@row, "Yes", "No")) If they match it returns "yes": green checkmark If they both have values but they don't match it…
-
Formula to generate the expiration date, 1 year after date signed?
I am trying to figure out a formula that can generate the "expiration" date based on the "date last signed". The "expiration" date is one year from "date last signed". Note, dependencies are off. Example: If the "Date Last Signed" is 01/01/20 then the "Expiration" date should be 01/01/21. Seems pretty straight forward but…
-
Why can't I convert =IF(COUNTIF(Email:Email, Email1) > 1, 1) to a Column Formula?
Brand new to this app. My formula: The error: Where that link takes me:
-
Help with date formula's
I am creating a tracker that will keep track of vacation days, and the number of days an employee gets each year depends on how long they have been an employee. The days are earned each year on their anniversary. I have almost everything working with the exception of 1 thing. Let's say I have an employee that started…
-
Conditional formatting on a cell that has multiple date input from a form
Help needed and much appreciated!!! I have a built a form to track new contracts, I input the data manually and one of the options are upgrades. The upgrade field in the form is a drop-down multi select option and I would like a different column to automatically calculate the price based on the options selected. Is is it…
-
COUNTIFS PARENT cross reference
In my summary sheet, I need to cross reference the PARENT rows in my data sheet (status) to count the number of open non-conformities (with less than 100% complete). Basically, the counting in summary sheet needs to take into consideration two conditions in the status sheet: Be a PARENT row, and % complete <1 I have tried…