Sign in to join the conversation:
Hi everyone, I have a project that spans multiple years and contains many workflows. I would like to be able to track the critical path to different milestones (not just the last task in the sheet). Are there any tricks to doing this in smartsheet?
Hi kblack,
Can you please send me an email - kara.lumley@smartsheet.com ?
I would like to discuss this further with you.
Thank you!
Kara
Hi. Did you figure this out? I need to do the exact same thing. Thanks,
Warren
Same here .... I need this feature urgently. There are critical milestone and none critical milestones. How do I select specific milestone to be in the critical path calculation?
Thanks
Alon Dagan
I got the same issue, does it have any update. Many thanks
I've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
