-
Column formula do not appear in form
Hello, Hope you all are good in this crazy time. I'm really new in smartsheet and maybe what I'm trying to do is not viable, so I'll try to explain myself as details as possible: I want to create a form with some fields "auto-fillable" based on a cross-reference VLOOKUP formula. I have a main sheet and there is a column…
-
Getting #UNPARSEABLE after using IFERROR
Hi all, I've got this awesome formula (Thanks, Paul Newcome!), which calculates the difference in months between two dates: =(12 - MONTH([Actual Study End Date]@row) + (((YEAR([Expected Expiration Date]@row) - YEAR([Actual Study End Date]@row)) * 12) - 12) + MONTH([Expected Expiration Date]@row)) +…
-
Formula Dates vs Gantt display
Hi all, I have an issue using function + dates + showing them in a Gantt chart. The scenario is the following: I have three columns set as type Date: Contractual date, Starting date (of execution) and End date (of execution) The Contractual date is filled in by a conditional hyperlink to the actual project (something like…
-
Formula returning #nomatch when flash filled (original formula does not have error)
Hello - I wrote an IF(Index(Match formula to reference a checkbox between 2 sheets (if checked in reference sheet, check in target sheet). The original formula works, but when I attempt to fill the formula down my column, it starts throwing #NOMATCH errors. I tried re-typing the formula from scratch, but no luck. Target…
-
Cannot calculate future date based on two source fields.
When adding a set of days to a historical date usually that will give you a future date example: =[Sale date]@row + [Delivery days]@row will give me a future date When using Data mesh or Vlookup to bring the two source fields to another reference smartsheet, the delivery days will add to the year instead of the days, thus…
-
Formula to Produce Symbol based on other Symbols
I have a very complex formula I need help with... using dates and symbols in other columns to dictate the symbol produced. The 'LIVE' column below will populate with green, yellow, red, or grey based on a combination of the following specifications: 1) If Target Go-Live date is passed AND Kick-Off is green, AND MSA is…
-
Count how many jobs start in a month
I am trying to create a formula that counts how many jobs are due to start in a month, that havent already been started. I have created the below formula to try and count the jobs in the current month: =COUNTIFS({Tippa JC Status}, ="", {Tippa Start}, MONTH({Tippa Start}) = MONTH(TODAY())) Then I try and modify it to the…
-
SUMIF sum_range
Hello, I am trying to calculate the SUM in numerous columns based on if the Level Column contains certain text; e.g. SUMIF Level = L04 then SUM Column CAB 900 and I have this working with the formula =SUMIF(Level:Level, "L04", [CAB 900]:[CAB 900]) The problem I am having is that I will have 100+ columns and have to do this…
-
Formulas to identify duplicates
My company is assigning decals to vehicles to monitor our guests. Is there a formula to identify if a license plate has already received a decal if I am looking at my sheet? We will have 2000+ license plates and need this to be a quick glance, or automated notification. I know I am asking a lot so any help is appreciated.
-
Formula results in a Smartsheet form
I'm adapting an Excel-based grant application to Smartsheet. It's working well, but there's one feature in Excel that I don't know if the Smartsheet form can do. In the Excel version, we've included fields that automatically total different requested amounts and also show the average amount requested per participant. This…