-
Text to Number Issue
So the below formula however its resulting in a text result, i.e. left aligned. I'm then trying to run an AVG/Collect or AverageIF formula on this column however its providing a #DIVIDE BY ZERO result. Any idea/thoughts on how to resolve this? Below is the formula resulting in a 'text' result that I cant run a count/avg…
-
Where do I find my form to edit it?
I have created a dashboard and placed my form on the dashboard. I would like to change a couple of things on the form but I don't know where to find it to be able to edit it. I'm very new to Smartsheet, so please be gentle.
-
Summarizing labor hours per person across multiple sheets
I’m looking for some advice on how to achieve something. I manage multiple projects, each with their own project plan sheet. On each project plan sheet I have a column that lists the estimated labor hours for each task. On a dashboard I would like to be able to show the total labor hours broken out by person across all…
-
Dynamic View filter
I am revising a column in my source sheet. It has a dropdown window where I am adding more keywords. However, when I go to the dynamic view filters to search, the newly added keywords do not appear. Is there a limit as to how many items will show in a dynamic view filter dropdown menu?
-
Collapsing a project plan
I thought that I could create a template that I could copy and paste to the bottom of my Smartsheet to keep all of my PDCA projects together. But when I collapse the first one, it collapsing everything because it considers the first one to be the parent. Below is a snip it of what I am talking about. What can I do so that…
-
How to Filter on Blank Cells in a Multi-select Contact List Column
We have a ticketing system that has an assigned column that is a multi-select contact list column type. Before I switched it to multi-select I had a filter that showed the current user and any rows where the assigned column is blank. When I switched to multi-select the blank filter stopped working. I tried a helper column…
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
Date of Birth - Date Column
I have a date column in my sheet but it only goes back to 2011. I need people to put in their Date of Birth so that does not work. Is this a Smartsheet limitation or is there a way to correct this?
-
How to reference Project Metadata and display sum of $ as metric value on a dashboard?
Hi all - new here. We recently procured Smartsheet for our PMO, and I have to say I am really struggling with what seem like genuinely basic things. We had a Smartsheet consultant help with design and building it out, however it just seems so cumbersome and unnecessarily complicated, with very limited customization…
-
DataMesh Note Section
Within DataMesh it would be really helpful to include an additional field to provide a description of what workspace/purpose etc. that the DataMesh config is applicable to. Currently I have ~50 configs for various workspaces. I have come up with a naming structure however I am limited to how much space I can use.