MS Project has a lot of built in features that SmartSheet just doesn't have. Such as calculating if something is late, setting a deadline that flags if the date moves, calculating AWC and SWC, etc. To…
Hi All - I'd like to use a formula to evaluate status of red OR yellow then flag if red or yellow. I think I'm close but it's not working, please help. Here is what I have: =IF(OR([Status6] = "Red", […
I cant seem to get the formula correct for this scenario: If "End Date" is Past Due AND "% Complete" is NOT 100% = "Complete" to turn flag red in "At Risk" column Am I correct that the formula would g…
We would like to write logic to display all predecessor task NAMES in a new column. So we want the predecessor task ID to be in its usual column, and we want a NEW column that shows the NAMES of the p…
Hi I'm working a construction project, and need to use a formula (or another method). To have a cell generate a remainder duartion period, based on a set completion date and duration against the curre…
Forgive me if this topic has been covered before, I've done the best I can searching. So my employer wants to have our projects be listed in a sheet, each department in a different sheet and to have t…
Hello, I was wondering if there's a way to update the calendar/gantt settings to use quarters based off of our fiscal year. Is that an option? Example - Q1 would be November-January Thanks, -PJ
It's going on 14 days and I still have no idea how to access the Solutions PM templates discussed in this webinar: https://www.youtube.com/watch?v=fGdbyfiYFZo Customer Support has been no help what so…
