Sign in to join the conversation:
Similar to MS Project, is there a way to make tasks inactive so they show with strikethrough but do not affect the schedule/project timeline?
You will need to do some additional work. First you will need a column to designate needed vs. not needed. To get the strikethrough, you will need to set up conditional formatting that says to strikethrough if the "needed" box is not checked. Then you will need to build some automation (or build into existing) that basically that if the box is checked, include it or if the box is not checked, exclude it.
There are actually a few moving parts and options to accomplish what you need, so if you are able to provide screenshots and details on exactly how your timeline is working, etc., we could help you with a more specific solution.
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
