Hello, Can anyone suggest a way to manage this? I'd like to be able to count up time spent awaiting feedback from our client across various projects held in the same sheet. Essentially I need to be ab…
Hi, I am looking for a formula that can check for overlapping date ranges between of the sub tasks on a project. In the screenshot below the project has several sub tasks and I need a formula that wil…
Hello, My goal with using INDEX(COLLECT)) was to obtain information based on 3 different criteria, but in my source sheet there are multiple matches for the three criteria specified. What do I need to…
Hi all, I am pretty new to Smartsheet and will need your help to build a dashboard. What is the best practice to create one? GRID I have multiple salespeople in my team, each of them have their own gr…
While rewriting my 2016 Smartsheet application that tracks all sorts of weekly and monthly data on projects and employee billable hours charges, I needed to be able to store those results in archive f…
Links between sheets are not working. I've seen status updates on this from people in the past, but am not sure if this is an ongoing issue or if it has been resolved. If I need to submit a ticket to …
I am currently trying to develop a project plan sheet, and I am wanting to be able to notify someone when the predecessor task was completed so they know they can start working. For example if John ha…
Hello, How would i write a formula when looking for data between a certain period i.e. I want to find the number of tasks marked 'complete' between March 1 through March 31? Thanks.
I know you can lock rows and columns, but can you lock certain comments so that those with certain access levels cannot see what is in the comments? For example, we are giving view only access to cert…
Our marketing agency uses a SmartSheet form to collect new projects (project intake sheet), then we create individual sheets for each sold project (project plan). We execute the project as laid out in…