Project Management
Discussion List
- On a Smartsheet project intake form, I have several Yes or No dropdown selections. If Yes, the user must answer additional questions. If No, they do not and those cells are left blank. Auditors do not…
- Hi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basically, i need to c…
- Hello, how can I leverage the metric widget in a project Dashboard to display 'Week Ending X/XX/XXXX' that updates automatically? For example, for the week of 11/8/21-11/12/21, I would want the widget…
- I have several workspaces for closed or past projects that I would like to archive. We do NOT have Control Center. I act as more of an admin (and I'm also a Smartsheet Admin) for the owners of the pro…
- Hi all, I currently have created a form to which PMs submit their project to discuss on a weekly call for authorisation. I want to incorporate a 'Required Members' reminder for the likes of VPs and st…
- I am looking to automate the colour “status” for my rows based on the health of the action - a calculation based on the ‘% Complete’ and the ‘Due Date’. The goal is to demonstrate a contextual health …
- Hello, I'm working on a formula to show the remaining duration of a task. I'd like to calculate workdays using the planned end date minus either today or the planned start date, whichever is closer to…
- I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would er…
- Currently using =COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN()) with check-boxes as a quick look to tell how many deliverables have currently been accounted for. I need to add additional lines un…
- I would like to have Task D begin when Task A or Task B is completed. How can I set multiple predecessors? Task Name | Start Date | End Date | Duration | Predecessor Task A | 7/1/2021 Task B | 7/11/20…
