-
How can I ignore a blank cell in an IF formula?
I'm calculating the workdays between two days and updating the status in a different column. How do I make the formula ignore blank cells in the Install Difference column? =IF([Install Difference]@row >= 21, "Late Over 4 Weeks", IF([Install Difference]@row >= 11, "Late Over 2 Weeks", IF([Install Difference]@row >= 2,…
-
Weird Formula Help
I have the following columns in my sheet: Is This An Object? (a drop down "Yes" or "No" column) Object # Box # Folder # HW ID I need a formula for the HW ID column that mirrors the "Object #" IF the "Is This An Object?" cell is "Yes". However, IF the "Is This An Object?" cell is "No", then I want the HW ID column to…
-
Vlookup - #unparseable result
I built a tracker that is populated with an intake form. One of the criteria is a broker code, that when entered on the tracker from the form, is vlookup’d from a reference sheet and gives me the broker’s name, their branch code and branch name. This works perfectly fine for our purpose. Our team has now been tasked with…
-
Please could someone kindly help me with this INDEX/MATCH/IF /AND Formula
Hello There Smartsheet Community Please could you kindly point me in the right direction with my formula? Sheet 1 Contains the following sheet references "Status" = Jira Status "MMP" = MMP I need to update the value of "Validation NL" based upon the following criteria: If "MMP" in sheet 1 matches "Req ID" in sheet 2 and…
-
Convert Variance in project sheet to weeks
Hi I'm using 5 days a week in my project sheets and I want to convert the variance column into weeks baseline in weeks in working out the duration between the baselines dates (please ignore) please can you advise the best way? @Paul Newcome @jmyzk_cloudsmart_jp @Matt Lynn-PCG
-
Calculating past date from a January Birthday
I thought I had this all figured out a while back, until diving back in now I notice that a handful of my dates are not working correctly. I figured out it is all of the rows where the person has a birthday in the first couple weeks of January. I want to take the birthday and create a date range that a survey can be…
-
How do add columns in smartsheets dynamically based on a condition ?
I have the date of implementation of the project and I need to dynamically add the columns based on the date. Like for example if I had a 1-2-2024 as my date. It must give ,me 12 months for that date like march 2024 to jan 2025 each column contains 1 month a total of 12 columns and adding to it I have so many projects some…
-
Create master list sheet for multiple individual sheets and count the data from individual sheets
Hi there I have a question to how to automatically link the count formula from one master list to individual sheet. Below is my workflow. I have created multiple individual sheets for each of my program to track the program status, (Pink Heading) Sheet 1 - Program 123, Sheet 2 - Program 124 … Then, I created a (Blue…
-
Help with Health color formula
I need help with my Health column formulas. I cannot figure out why it's not working. What am I missing? Available health options: Red, Yellow, Green, Gray Health formula: =IF(COUNT(CHILDREN()) > 0, IF(COUNTIFS(CHILDREN(), "Red") > 0, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") > 0, "Yellow", "Green")), IF(AND(ISBLANK([End…
-
Formula keeps giving back #UNPARSEABLE
My below formula keeps giving me an error and I can't see to find the problem. It also seems to not be recognizing the column references when the names match exactly. =COUNTIFS([Project Start Date]:[Project Start Date], >=DATE(2023, 1, 1), [Project Status]:[Project Status], OR(@cell = "green", @cell = "yellow" ), [PD…