-
Need help vlookup and a migraine. Help with vlookup may help with migraine.
-
IF Multiple Codes have open Status then Duplicate is True
I need some help with a formula that is partially working. I've tried a few ways to code this, but gets an error so I'm probably missing something... During our intake process using Smartsheet a form can be filled out by multiple people. To my knowledge, there isn't an easy way to prevent multiple submissions for the same…
-
Help with RYGB Formula for Days past Start Date, Blue = Complete Status from Multi Select
Hello Smartsheets Friends, Using a Smartsheet for keeping track of Activation Status. Here is what I am hoping to achieve. 1-7 Days from Handover Date = Activation Call Status - Green 8-14 Days from Handover Date = Activation Call Status - Yellow 15+ Days from Handover Date = Activation Call Status - Red When customer…
-
LEN counts "Space" as a character
Hello, How do I prevent LEN from counting spaces between words as characters? Thank you. =LEN([Letters]@row) * 10.75 * Height@row
-
Say Hello to PPM Function TotalFloat
Hi Community, We are happy to announce the addition of the TotalFloat function to Smartsheet’s powerful set of Project and Portfolio Management capabilities. The TotalFloat() function calculates the number of working days that a task can be delayed without impacting the Project Finish Date. This new formula function will…
-
Turn cell Green, Yellow or red depending on how many days have elapsed past a date in another column
Hello Smartsheet friends, I've found several past due or days before past due formulas but have not been able to find one specific to this case. We use a smartsheet for account management. I would like to have a cell turn a color based on the variables below, based on how many days have elapsed past the date in another…
-
Using IF and OR together
I am very new to smartsheet and I am trying to condition a cell to be "Yes" or "No" based on items noted in a specific column =IF(CONTAINS("ItemA", Order:Order), "Yes", "No") ...but I also want to include OR IF "Item B" OR IF "item C" is there The don't all have to be there to be "Yes" just at least one of them Thank you…
-
Help with conditional formula
Hi i am asking your help to replicate the following formula that i have in excel to SmartSheet =IF(AND(Q2<>P2,R2="No- implementation date is at risk without external (to the project team) involvement"),"Red - Off Track",(IF(AND(Q2<>P2,R2="Yes- implementation date is still achievable"),"Yellow - At Risk",(IF(Q2<=P2,"Green -…
-
Using CountIfs with several criteria including names, status, and date range
I've created a sheet to build metrics from a very large source sheet. I'm trying to count based on the following: the column {Module 3 - Section Owner} matches a cell in this metric sheet in the "Primary Column" a Date in the {End Date} that is between Today() and the next 7 days. I created three cells that determine what…
-
Formula is not working
Hi - I cannot figure out why this formula won't work - =IF(AND(TODAY(10) >= [End Date]@row, IF([% Complete]@row, <0.75, "yellow"))) Thanks for your help!