-
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…
-
Import of Excel File
@Paul Newcome Hi Paul hope you don't mind me tagging you into this. the attached file with the tab called "live recording" is the file i am trying to import into Smartsheet's. the issues I am having ( a big issue ) once I import this file into timesheets all my formulas are #UNPARSEABLE. I am really struggling to…
-
Use a reference calendar sheet as a look up table to return values to a resource planning sheet
Hello, I have a resource planning sheet (Controls Resource Planning) that lists task for individuals along with other pertinent information. I have a Start Date and End Date column. I also have Period Start and Period Finish columns. Our company fiscal calendar consists of thirteen, four-week periods. Since I don't have…
-
Return true of Date equals a date within a range of specified dates
helper column =IF([Deploy Date]@row = [Deploy Date]29, 1, 0) Works fine. If the date in the row equals the date in row 29 - returns 1 However i'd like it to search within a range of dates and i'm clearly missing something. =IF([Deploy Date]@row = [Deploy Date]28:[Deploy Date]39, 1, 0)) I'd like if the deploy date @ row…
-
Modify criteria for Schedule Health
Hello, I am trying to modify the criteria for the Schedule Health using the Project Management Office Template (https://app.smartsheet.com/b/publish?EQBCT=8c1ace8ce2d14472a986005d454626d8) Currently it calculates the health based off of the actual and target start/end dates, however, I'd like for it to also factor in the %…