-
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…
-
Need help with the formula to update status based on changes to a field
Hi, I need help with a formula to automatically update status based on changes to multiple fields for example- I have =IF([Assigned To]@row <> "", "In Progress") to change status to In Progress when an input(name) is entered in the "assigned to" field Now, I want the status to change to "In Review" when a name is entered…
-
Formula to Check a box at different indention levels
Hey there, Trying to figure out a formula to automatically check the boxes based on how many times a task has been indented, like this: I know I can set the Activity column to: =IF(COUNT(CHILDREN([Task Name]@row)) = 0, 1), but I don't know how to do the others. Any help would be appreciated!