-
Leave field Blank when using IF formula, on Date Row.
Hello, I would be eternally grateful if someone can help me, I have tried ISBLANK, and "" to leave the collum's empty but its not working. I have the IF formula to turn Red when the date is nearing 30 days, Yellow when the date is nearing 60 days, and Green when the date is over 60 days. But some fields will be blank; on…
-
Check a Box when a match is made on two criteria's between two sheets
Can someone assist on how I can revise the following formula so that a check a box is checked when a match is made on two criteria's between two sheets, Contract ID the two date fields. Both the contract ID and date fields are real values (not calculated). However, the formula is returning blank in the 2nd sheet (snippet…
-
Formula to auto increment unique IDs
Referencing the example image below, I'm looking for a formula that will automatically create incrementally numbered unique IDs, like what's shown in the column "Unique device ID within each room". That column's ID needs to be unique to the room number, but the ID is repeated in other room numbers, as shown by COMPUTER1…
-
Date Format Question
Hello Smartsheet Community, How can I get the Date Helper column below to automatically show the date format as D-M-YYYY? There is a formula in that column and it's a date column. When I click on the date format button and select another format type, it does not do anything. The D-M-YYYY format seems to be the only one…
-
Date formula to show when retraining is due based on number of months and/or year(s).
I'd like to be able to use a formula to add either 1 year, 3 years, 5 years etc. to show when retraining is due based on the Training Completion Date. Any suggestions on how to approach or a date type formula that will add one, three, or 5 years to the Training Completion Date would be greatly appreciated.
-
Contains function - leave unchanged unless condition is met
I need to update cell A in each row of a very large sheet only if a certain substring exists in cell B in the same row. If the substring does not exist in cell B, leave the existing value in place, do NOT blank it out. I cannot use any alternative "else" assignment approach because these cells are already populated. In…
-
SUMIFS and CONTAINS with column criteria, Within CONTAINS can a "Not Equal To" operator be used.
Hello all!!! I am trying to modify a working equation "=SUMIFS([Task Ratio]:[Task Ratio], NeedsText:NeedsText, CONTAINS("Quick Win", @cell), AssignedText:AssignedText, CONTAINS("First.Last1", @cell)) The modification that I am attempting is to add another CONTAINS statement to the above. I am trying to add…
-
Convert numbers into dates for this CY
I need a formula that converts numbers into dates for this CY. For example, 366 needs to convert to 12/31/2024
-
Automatic Predecessor Adjustment
Hey All! I have a question about how to have predecessors or just tasks in a schedule to automatically update when they are moved in the schedule. I am trying to create a production schedule for our Sheet Metal shop and it is created with the fabrication packages released from the Eng Dept. Sometimes the schedule needs to…
-
Countifs for Portfolio Summary
Hello! I am trying to do a portfolio summary for my PMO. I want to count the number of active projects in each project stage, for example, active projects in the planning stage. I have a sheet that has a column for if the project is active and another for the project stage, but I don't know how to structure the formula.…