Hi! I've been using SmartSheet to track progress of different business units on a particular project. Each unit has its own sheet containing grid data that they fill out, as well as sheet summary data…
HI There, I feel this should be easy to figure out but i cant seem to! PLEASE HELP?! I have a column called "STATUS" , I have a drop down menu with the following under Status STAUS On Hold In Progress…
Hello, I am still fairly new to Smartsheet and need some help turning around data from a survey I sent out. I have 600+ responses that I used the Request an Update function in Smartsheet to obtain, th…
Hello - Hopefully this is a simple question. I have a column that I am trying to sum the data in but the cells quantities and data inside each cell. Is it possible to sum the total quantity for the co…
When configuring an Alert Someone workflow and selecting "send to contacts in a cell", is it possible to reference a contact in a Sheet Summary field for the sheet? The drop down selection only shows …
I am creating a chart on a dash board using a sheet summary report pulling data from 2 sheets. I am having difficulty arranging the columns as desired no matter how I adjust the widget tools or the co…
In my sheet summary, I am trying to sum/total a column where the cell values are populated as a result of a formula. I can't seem to get a value. The formula for the cells I am trying to sum is this: …
Hello community, there is a formula problem which troubles me slightly. These formulas work perfectly fine =COUNTIFS({6M_category}, HAS(@cell, [Primary Column]@row), {Time of occurence}, >=[Start Date…
Our marketing folks use a new sheet for every campaign. During the span of a few months, there could be several dozen such sheets active. They are all built from a template and reside in the same fold…
Hi there, I want to add a few sheets in card and calendar view on a dashboard. Is this possible? I only see that reports can be added on dashboards, how do we also add sheets. Thank you, Esperanza