-
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!
-
Date Fromat
Hi, I was wondering how I would change the date format to USA to UK. thanks in advance.
-
Join/Collect/FIND --> Sorting & Concatenation query
Hi All - firstly thank you for all the prior forum articles around JOIN/Collect and multi-select cells requiring HAS/FIND usage, it gave me a terrific starting point to now ask my question around. I have a list of employees in a sheet and I manually track competencies that they can perform technical interviews for. I have…