-
Right formula
I am looking to extract the string of data to the right of the LAST "/". Here is my formula =RIGHT([HELP-Phase]@row, FIND(" / ", [HELP-Phase]@row)) HELP-Phase cell contains the below; Project Platform (2022-1107) / Core Concept Design and Business Modeling / Creative Development and Attraction Design (Phase 2) What I amโฆ
-
Explain =IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green
Good evening all, Can you explain what this formula is actually doing? This is the standard formula that is in the project plan in the Smartsheet PMO template. I think it should change "red" if my task is behind schedule. None of my late tasks are turning red, the project plan remains green for everything :-( Please helpโฆ
-
Index Collect with date within 7 days
Here is the setup: I have two sheets: November Schedule (where the formula will live) Columns Completion Date (Date Column) Hidden Lead Tech (Formula lives here) Historical Roster Columns Created (Date Column) Lead Tech {Historical Roster Range 1} is the Lead Tech column {Historical Roster Range 2} is the Created column Iโฆ
-
Why does my Metrics constantly stop calculating correctly?
I've been making a "Metrics" sheet for some time now, and in the beginning everything was calculating fine. But it seems to be when I add more "data tables" if you will, or more metrics, some tables stop calculating correctly. Here is what my sheet looks like for a better understanding So, the first few-ish sections willโฆ
-
PTO ACCURAL TO REFRESH ON JAN 1ST
Has anyone figured out how to refresh the pto accrual on Jan 1st? This is my formula that works fine in this current year: =IF([EMPLOYMENT TYPE]@row = "FULL-TIME", [WEEKS WORKED FROM START MONTH AND DAY TO DATE]@row * 1.66, 0)
-
Formulas for
Is there a way to change a formula to a static value, once a date (or other item) is entered. ie. So once a formula pulls info it updates the cell. At the end of the month, ( a date is reached) it removes the cell formula, but the info in the cell stays in place.
-
Change Symbol based on date / clear if blank
I'm wanting the symbol to change based on the date field. If date is today (or in the past), Red If date is tomorrow, turn Yellow If date is past tomorrow (in the future), Green If date is blank, Blank - No color/Symbol This was working to some degree, and somehow I broke it.... :) =IF([Scheduled End Date]@row <= TODAY(),โฆ
-
Multi-select Dropdown - Select Starting Number characters From Each Option
Hello, I am trying to create a helper column that pulls data from one of my Multi-select Dropdown columns. The data I want the helper column to collect is the number portion of each option selected in the Multi-select Dropdown. I've looked a several posts showing how to pull text strings from multi-select options, but itโฆ
-
Find and replace or substitute
Hello, What is the best way to turn ###-###-#### into ########## ? Some entries have parentheses, dashes or spaces, but it needs to pull just the numbers. I figured it would be either find and replace or substitute, but I'm not sure if I need an additional app to do those. Any help would be appreciated!
-
Count "Assigned to" and Completed Year from Multiple sheets
I have 15 sheets with an "Assigned To" column. When the task it completed the task moves to an Archive sheet (there are 15 Archive sheets also) I need to count the number of completed tasks for each "assigned To" person and the year that it was completed. I have added a Date Modified column to the Archive sheet. Below is aโฆ