-
Clear diamond in addition to a milestone marker?
I have a sheet that has a Gantt chart with milestones. The milestone marker I want displays appropriately. However, when I export to PDF, I also get a clear diamond at the far left of the Gantt chart. Can I get rid of the clear diamonds?
-
Trying to get data using the RIGHT formula
I have the following data where I am trying to parse the (ISPHUBS-6AAA) from the string below. Assets 1 = ORRR39-ORMOOO-BEACH (ISPHUBS-6AAA) I use the RIGHT formula ... =RIGHT([Assets 1]@row, FIND("(", [Assets 1]@row)) But I get the following string returned Result = -BEACH (ISPHUBS-6AAA) How do I get just the…
-
How to Set Up Tracking for customer builds - Recommendation for best Smartsheet approach
Hello Everyone, We have an item that is the same. We build it at customer locations and each build projects has the same milestones. We want to start using Smartsheets to plan and track each project and have 2 dashboards - 1 focused on the metrics of open projects and then one for tracking a "grade" per total project so…
-
IMS to to do RAIL sheet
My IMS has a list of Critical Items that I would like tracked in a RAIL sheet Task Name, Start, Finish and Assigned to, Currently I have been coping and pasting these values into my RAIL my RAIL sheet column are Task name, Assigned to, Start date, Due date, Notes, Priority I currently use my RAIL to track meeting minutes…
-
SUMIFS formula
In my Sheet Summary, I am using the formula =SUMIFS(Shipped:Shipped, [Date Manufacturing]:[Date Manufacturing], YEAR(@cell) = 2023) + SUMIFS(Pending:Pending, [Date Manufacturing]:[Date Manufacturing], YEAR(@cell) = 2023) + SUMIFS(Scheduled:Scheduled, [Date Manufacturing]:[Date Manufacturing], YEAR(@cell) = 2023) across…
-
Deleting Cross Sheet References // Reference Manager
Anyone else not able to delete Cross Sheet References? I have a total of 8 CSR's that I have Deleted multiple times...but they keep showing up again in the Reference Manager. I even deleted the column in the source sheet that the reference was pointing to and they still won't completely delete... I submitted a support case…
-
Portfolio Metrics
I am trying to get a count of all my projects in my project intake sheet. I am using the formula below to reference my intake sheet but it is returning 0 when I have 12. What am I missing? =COUNTIF({2024 PROJECT INTAKE PROJECT ID}, <>"PROJECT ID") Thanks in advance
-
Nested OR statement to return a different value
I am trying to create a formula where it looks at 3 cells and returns a different value for the cell where the statement is true, but if multiple cells return true it also needs to return the last cell where that true value occurred: =IF(OR([23-24 SY Visit Count]@row >= 1, 1, OR([22-23 SY Visit Count]@row >= 1, 2,…
-
Helper Columns & Sheet Summaries
Hi, Can you tell me how to link field from summary sheets into a cell on a different sheet in Smartsheet? I have seen other chats on using helper columns, but nothing that provides guidance on the proper formula to use to pull that information. Is there a way to do this?
-
Cross Sheet References
Has the # of allowable cross sheet references changed over the last year? We have a document that last fall had over twice the amount of cross sheet references as this year. All we do is rename the smartsheet and update to the new 2024 smartsheets. We had a column for Spring and Fall. This year we can't even get all the…