-
Dynamic Dropdown List
Has anyone created a workaround or built a solution that provides dynamic dropdown lists?
-
What is missing from the below if formula?
=if(@row23 = Y, "0.1", "0") I am wanting Smartsheet to put 0.1 in a cell if the reference cell is a Y and 0 if the reference cell is a N.
-
NETDAYS returning #INVALID DATA TYPE
Hi - I'm trying to calculate the number of days between two dates in a sheet. I have both of my columns that contain the start and end dates set up as DATE column type. They both contain dates. I use the formula "=NETDAYS([Hotel Check-In Date]@row, [Hotel Check-Out Date]@row)". I have tried making the results column a…
-
If, And, Or formula
Looking to calc MQLs if FY = FY24 (easy part), but each region has a different conversion rate and that's where I'm struggling. My formula is something along the lines of: IF ([FY]@row = "FY24"), and (or ([Region]@row is "ANZ", multiply [Lead forecast]@row * 25%), ([Region]@row is "ASEAN", multiply [Lead forecast]@row *…
-
Multiple IF Statement Returning Different Text
Hi Everyone, I am trying to write a formula that will look at a cell and if certain wording is not in the cell then return a value to a new cell. The information is from a multiple dropdown selection column. Here is an example of what i am trying to do. Dropdown List Would Populate the Missing Color column based on a…
-
Gant Chart - How can we track the planned versus actual LAG days?
Hello Everyone, I appreciate any help on this topic. I am starting a study of our construction efficiency looking at our last 30 projects. One of the data points we are digging into is our "planned" LAG days between certain trade partners. (LAG days are inside of our defined working days, and do not include non-working…
-
How to Add Categories in Personal Budget Management Template
Hello. I am new-ish to SmartSheet. I am wondering if anyone can help me understand how to add more budget categories to the existing Personal Budget Management project template (specifically trying to add categories to the "Budget Setup" sheet in a way that keeps the formulas in tact... currently only a certain number of…
-
IF/CONTAINS Formula Question
Right now I'm trying to experiment with pulling information from one sheet to another based on if the creation day and submitter match, and I'm struggling to get it to work. First I was getting an "INVALID DATA TYPE" error, so I tried starting from scratch but now I'm getting an "INCORRECT ARGUMENT" error, so I guess…
-
I need some help changing my At Risk formula so it doesn't flag when dates are empty
How can I change this formula so that if there are NO start dates and end dates in a row when it is set to Not Started, it does NOT show as flagged. Here is what it is currently doing: Here are the formulas I currently have set up for Status: =IF(ISBLANK(Complete@row), "", IF(Complete@row = "Not Started", "Gray",…
-
Formula Cell Reference Limit (25,000,000) Not Refreshing
Hi all, We're having an issue where the 25,000,000 formula cell reference limit was reached after adding a new column, but even after deleting way more columns and cell references than we added, it's still showing the attached error message and not letting us move any new rows into the sheet. We should be far below the…
