Hi! I am having an issue with using the COUNTIF and HAS functions together to count all instances in a select all that applies column. I'm specifically using this on a metric sheet to add it on my dashboard. Any ideas on what I'm doing wrong?
This discussion has been merged.
Smartsheet Community: Once The Baseline is Set. It Would Be Nice to Have The Ability to Add New Tasks and for those Tasks to be Added to The Baseline without Re-Setting it. Today, I have to Manual Change All the Dates. This Drastically Increase human Errors and is Very Time Consuming.
Hello! I am working on a column formula for a project plan where the RYGG ball and Task Status will automatically be updated based on the % complete and the due date. What I'm trying to solve for is: if % complete = 0 and start date is today or in the future, then stage is grey and status is "not started" if % complete =…
In our team project trackers, we are leveraging worksheets with grandparent/parent/child relationships to organize by the the different business/clients/projects. Our desired automated reporting output is to transpose most of what is captured in a row format into a column to enable a snapshot view that is horizontal in…
Is there any Smart Forms Templates that can be used? I wanted to make a smart form that allowed the easy use of Contractor SOW form or something similar to it. I wanted to be able to have contractors fill it out and state their information such as, certifications relevant to work being completed, personnel on site during…
Currently Holidays can be configured in 2 locations on Smartsheet. At the administrator portal and at the sheet level. It would be ideal if at the sheet level you could select pull in holidays from your administrative settings. This should be something you can do when creating a new sheet from a template so that you do not…
Hello, I am looking for help utilizing a formula to hide the #DIVIDE BY ZERO error message. My current formula in the "Change" column is simple: =([Availability %]@row - [Previous Availability %]@row) / [Previous Availability %]@row But for any cells in the "Previous Availability %" column that have 0%, I get the #DIVIDE…
Hello I've completed the project intake form which has populated the Project Intake Sheet in the PMO Template set. I've then followed the instructions and copied the Project ID into the Project ID column in the Project Metadata sheet. When I do this, the rest of the data, e.g. Project Name, Project Manager etc is just…
Hi I want to know if there is a simple way of keeping a log of baselines, e.g. each time it is reset, the old baseline is logged, similar to version control. The idea is that at the end of a project (which underwent change control resulting in the timeline needing to be re-baselined) we will be able to review the changes…