-
WBS Calculation
I use the WBS template from Smartsheet. But find the WBS phase to be in error. The formula: =LEFT(WBS@row) How can I refine my formula so that it will capture the LEFT for WBS 1 - 9, but Abel to capture 2 digits numbers as well? Thanks for any assistance and guidance.
-
Crtitical Path not working correctly
Hi Team, I have created a plan for around 2000 line items with the all the dependencies and dates settings, when we enabled the critical path, we are able to see only few boxes, I was expecting the critical path from start to finish. Adding screenshot for reference, quick help in this regard will be appreciated, I have…
-
JOIN COLLECT MATCH Database
I am pulling data into a separate sheet (database) from a referenced sheet "Pipeline". In the Pipeline there are two columns, Index and Acronym. In the database I want these two column row data to JOIN together in a column named "Project Number" by recognising the same Index number in the Database and matching it to the…
-
Why do two Smartsheet sheets show same dates differently despite confirming format and timezone?
I've noticed a discrepancy in the displayed dates between two Smartsheet sheets, despite having checked for common reasons like date format, timezone settings, and data entry errors. What other factors should I consider to troubleshoot this issue effectively?"
-
Weird issue - COUNTIF Date Cross-sheet Reference
Hi - I'm doing a very simple cross-sheet reference for a count of dates and it's not working. Sheet 1: Date column has a series of serial dates. Column14 has a formula that is not working. Sheet 2: This has a Date Completed column. The formula in Sheet 1 in Column 14 is: =COUNTIF(Date:Date, {BPD-DateCompleted}) - ...where…
-
Children Parent % not calculating
Hello, I'm trying to build a sheet that calculates a percentage off of a Status column, but the column is not returning a percentage and the =AVG(Children) section. This is my mess of a formula =IF(IsParent@row = 0, IF(OR([Rally Status]@row = "Submitted", [Rally Status]@row = "Acknowledged", [Rally Status]@row = "Not…
-
Countifs multi select column and year column with contains
Hello! I have a multi-select column from which I am able to get a summary formula to count correctly, but every attempt I've made to account for the year from a second column has returned errors of some kind. The Year column has a formula in it as well: =YEAR([Contract Fully Executed Date]@row) This is the formula that…
-
Help stacking COUNTIFS?
I have two fully operational COUNTIFS functions that calculate independently without issue. One counts how many absences occurred in a specific time range by referencing a date column on an attendance tracking sheet. The other counts how many absences occurred in a specific location by referencing a location column on the…
-
Using Nested If and Formula to Set Value of Field
I'm trying to set the value of a field using an IF statement based upon a calculated number in a column called "Tier Score". =IF ([Tier Score]@row <= 17, "Tier 3", IF ([Tier Score]@row <= 25, "Tier 2", IF ([Tier Score]@row >= 26, "Tier 1"))) I keep getting UNPARSABLE. Thanks
-
Need help to auto populate a formula to display a number
It is simply EYYWK## -YY= year (e.g., 24 for 2024) -WK=week (e.g. 15 for right now. The 15th week of the year) -##=sequential e.g., 3x E-runs have been created this week, so the last "Full# in the book is E241503