Sign in to join the conversation:
Is there a way to set a dynamic column to be the % Complete column for the purpose of setting the Task Completion bar?
All help is appreciated.
Hi Ben,
To accomplish this, open the Project Settings on the sheet and set the % Complete Column drop-down list (under Options) to reflect the column you've assigned as the % Completed Column.
If needed, more information on this can be found in our help article: https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors#Complete
I am trying to write a cross sheet formula and keep getting the incorrect argument set error. The formula I wrote is: =SUMIFS({Total Poles}, {Vendor}, "ALLO", {Date}, >=TODAY(-30)) My formula is stating that I sound sum the amount of poles where the vendor column is Allo and where the date column lists dates within the…
I have a risk sheet with a system generated id column (ACT-0001); etc. In the risk sheet I have a helper column to identify if the risk is linked to a task in my project plan sheet. In my project plan sheet, I have a column called RiskID that contains a string of risks (ACT-001; ACT-0002; etc.) linked to a task. The risks…
Hi, I am using this formula =IF([Warranty Status]@row = "Warranty Expired", IF(AND([Asset Status]@row = "In-Stock), "Out Of Warranty","")) Its says the formula is unparseable. I can't figure out the issue with the formula. Help is appreciated.
