-
Count formulae
Hi all, Need a bit of help with constructing a formulae to input into a sheet summary box for the below situations: To calculate the count of 'Medical Device Related' category from the 'Relevant System' column Same as the above but for 'Non-Medical Related' category I want to have a breakdown of the sub-categories for each…
-
How to keep changes in chart colors?
I have created dashboards that include charts, for which I have selected specific colors for each category. Data for the charts come from different sheets. However, everytime I add a new row to the source sheet, I have to update manually the range of data in the dashboard. When I try to update the dashboard range, the app…
-
Resizing the Image Widget
Is there capability to adjust the white space around the image, in the Image widget on a dashboard? When I insert a logo, there is a good amount of white space bordering the image, and therefore takes up much more room that it needs to on the dashboard.
-
Building a sheet to best populate dashboards
Do you have any training material you can share on “best practices” for building a project plan/timeline to populate Dashboards correctly (e.g. metrics and tables). Examples of things I want to do: Present the overall project health as red, yellow, green; sum of late tasks; sum of tasks in progress and on-track; sum of…
-
OneNote integration in Smartsheet
Based on a suggestion I read on this board, I am posting a product enhancement request I just submitted for the community to see. Request OneNote integration in Smartsheet to easily paste in a link to a OneNote page/paragraph/section/section group in one click, and then designate whether to open in the OneNote desktop…
-
Index Function Help
I am trying to index data by date and have applied the formula to the column. The problem I am running into is the last data entry is repeating to the end of the dates I have listed for the year even though those dates have not occurred and are not even listed on the sheet I am looking to. =INDEX({Census}, MATCH(Date@row,…
-
Why would a formula work on one sheet but be #unparseable on another?
Hello All, I am trying to use a formula I use on one of my sheets to collect data. It works great, but I made a new sheet to capture the data as the other one is messy as I was still learning. My Formula works great on the original sheet, but when I use the same formula on my new sheet it comes back #unparseable. This is…
-
Flagging a Date and Time Overlap
Hello, I have a situation where we teach virtual classes that are each approximately 2- 4 hours in length, start and end at various times each day, and each requires a unique conference phone line dedicated to the class. We can teach as many as 6 to 8 classes in a day, but only have 4 conference lines. I'm trying to write…
-
Cells auto adjust based on forms submission
If a column has the wrap feature activated, it currently will not wrap if the data is submitted through a form. The only way around this is to refresh the Smartsheet. We currently use the form feature to have users submit information to our command center (control room) so we can see and address issues in real time. The…
-
Can I alter this formula to generate a date based off a deadline of the 4th Friday of every month?
As a form submits answers to my Smartsheet, the submission date is recorded under a column titled "Created." This information is submitted to a committee meeting on the 3rd Wednesday of every month, so I needed this formula to specify at which meeting date each response row will be considered. I found the formula below on…
