-
Service Contract Status Formula
Hi there, I'm trying to figure out a formula to return a Green/Yellow/Red Symbol based on a calculation of the date an item was purchased in comparison to the length of the service contract. I am able to get the "Green Symbol" using this formula: =IF([Service Contract Expiration]76 > TODAY(), "Green") But, I'd like to have…
-
Alternative Formula to MAXIFS
Hi Smartsheet community! I am trying to find the maximum value in a range with both Vertical and Horizontal criteria. I was able to get the answer I need for a similar column using SUMIFS to add all the values together. Now I need to find the max value (however, Smartsheet doesn't have the MAXIFS formula). Could someone…
-
Setting automation trigger to "If any of ..."
Please help! I am trying to create an automation workflow in which I can send an update request whenever ANY OF Column A, B or C HASNT been updated within the last 14 days, however if ANY of these 3 columns do have an update within the last 14 days the automation shouldnt trigger. Any suggestions? I am losing sleep over…
-
Probelm with IF(Contains formula
So I have a sheet where different fellows enter their budget through a form. I am trying to copy the budget from a certain fellow in the T&E Descritionary column on the basis of the submitter's BIN Number. The formula I am using is =IF(CONTAINS("507777", [Employee BIN]@row), [Fellow 2 $ Share]@row, IF(CONTAINS("507753",…
-
IF Function / Formula Help
I have created a budget sheet template and need to add seasonlisation to identify cross-charges by month. Rather than doing this manually every time, I would like to add a formula that pulls the data from another cell, but based on information in a 3rd cell. I was hoping it would be as simplistic as: =IF([Activity Month]3)…
-
Changing Status Dot Color Based On Deadline Column
Hi, I've tried looking up other questions to answer this and got as far as this formula [=IF(Deadline@row <= TODAY(+14), "Green", IF(Deadline@row <= TODAY(+7), "Yellow", IF(Deadline@row >= TODAY(0), "Red", "")))], but it's not providing the proper results. I have a Deadline column and a Status column (which is the RGY…
-
Confounding Behavior with IF Statement
Hello all, I've run into an issue around what should be an entry level IF statement. I'm comparing numbers in two columns, one of which is derived from a time calculation. The formula is looking to determine if the two values are greater than or equal to one another and outputs a simple "Yes" or "No" depending on the…
-
If, Networkdays, IfError
Hello everyone I’m in need of some more help with the below formula: =IFERROR(NETWORKDAYS(SupQARevCompleteDate@row, PlannerRevCompleteDate@row), "N/A") I need to add a condition to first check if Supplier QA Review Result = “Skip” then use EngRevCompleteDate@row instead of SupQARevCompleteDate@row. If Supplier QA Review…
-
IF Function
Hi - I tried using this formula =IF(Status@row, "Open", TODAY() - [Date of Intake]@row) And it's giving me INVALID DATA TYPE Subtracting the date of intake from TODAY() worked, so I think it's my IF function, but I can't figure out what it is… my [Status] column is made up of a dropdown of options (Open, In Progress,…
-
Help with cross year Working week formula
Hello Everyone. I'm after help making this work in a single column if possible I'm wanting to create a Due Column that will tell you if the end date of the task you are working on is in "This week", "Next Week" or "Beyond". The problem occurs when the task runs from December to January. As you can see from the above it…
