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…
Hello all! I have a trouble with one formula. The idea is, that I need to find an engineer name in AT LEAST (that's why I am using OR) one of the columns. The problem is, that the second range is a co…
Hi, I have several tasks Smartsheet's to manage different projects. In order to avoid keep checking each Smartsheet for due dates, I would like to have a "Summary" Smartsheet that brings only tasks th…
