-
Text/String Version of Max formula
I have a sheet where I am writing rows and not all entries will update each column. I want to reference that column on another sheet and only return the value that is not blank. I can't quite get the ISBLANK formula to work for this. I've done this with dates using =MAX(range). Not sure how to accomplish with text. Thanks…
-
If 2 criteria are met in 2 columns then sum a third column formula
Hi All, I had such great luck with help yesterday, I thought I would try again. I need to sum a column if 2 other column with specific criteria are met. This is the formula I have tried but it is not correct. I get UNPARSEABLE error. =IFS[Vendor Name]:[Vendor Name], "Curium", [Claim Status]:[Claim Status], "Pending - With…
-
how to get a form on smartsheet to automatically send to a certain manager based on type
In a recent video that was posted by John Cicero, he spoke about having the form automatically update the sheet with which manager that intake request should be submitted to. He used a "Match&Index" formula, although he did not show us the steps on which how he did this. I tried to read the help pages on Smartsheet showing…
-
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: