-
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…
-
Remove or Increase Cross Sheet Reference Limitations
Please consider removing or increasing cross-sheet reference limitations. I recently built a solution that would require me to manage 3-4 sheets each month for monthly audit results tracking from Joint Commission. I spent weeks building and testing and at the end had to add more questions (total of about 125 to the form.…
-
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…
-
Manuscript Tracker
Does anyone have a template for a manuscript tracker? Ideally I am hoping to build something that I can later publish for others to view and be able to search for themselves to see which publications they are either a byline author, group author, or in the acknowledgements.