I have a grid sheet full of contracts: each row is a contract. Each row has a START DATE and END DATE along with other details about the contract. I was tasked with creating a dashboard to represent t…
Hi there, I'm trying to build a summary sheet with formulas that COUNTIF cells in a column on another sheet CONTAIN a specific value (this column is multiselect dropdown). I've come up with things lik…
When creating a formula you're given the option to "Reference Another Sheet". I love this feature but it needs improvement because it ONLY gives you the option to create a new reference. Yes, you can …
I will use the following as an example for my problem: I have a pre-existing sheet ("Team Employees") where different teams record their # of employees once a month. This was used to track live staffi…
Hi All, I am working on a dashboard that displays various info and tasks in state of completion. I'm wanting to count how may checkboxes in a column to display a chart in my dashbord showing % complet…
Hi, Looking for help with Absolute references in cell formulas. I need the formula reference to remain the same even if the user moves or copies the cells to a different column. The scenario is Column…
I'm determining how long a person has been parked based on the parking lot zone number and the amount of money paid. I have a separate reference sheet that lays out the zone numbers, location names, a…
I am trying to set up a formula that lets me know if any of the Project Tittles in one sheet appear in any comments on a separate sheet. When the function should return "True", I get "#invalid data ty…
I have a few pivot tables set to update weekly, and seem to be refreshing the actual numbers just fine. However, I have some summary functions set up that have totally stopped working, instead giving …
hello, i came across a Video by Prodactive about S-Curves in smartsheet and so far everything has been working exactly as expected with one major exception; the "Actual" baseline. From the video and t…