-
Embedding a form into Dashboard
I am currently overhauling PTO dashboards for my company. Each dashboard has a link for an individual's sheet that records time off and the related request off form. Is there a way to embed a single form to the dashboard and have it link to individual's sheets instead of 15 different links?
-
Counting Harvey balls by row owner
One column of my sheet is a 5-symbol Harvey ball (Sunny, Partly Sunny, Cloudy, Rainy, Stormy) to show the relative health of a row. Another column is a Contact List type that shows to whom a row is assigned. I would like to extract the total number of non-Sunny rows per team member. What I have done is to add two columns.…
-
Linking Sheets
Due to the 200 column limit in a sheet, I have had to split my data into multiple sheets, using the project name as the Primary Column for each sheet. I know how to links cells and use IF formula to pull the Project Name column data, but I cannot for the life of me figure out how to automate it, where if I add a project…
-
Multiple Links to Another Sheet
Hello. I have several sub sheets that feed into a master sheet. In the master, all the tasks and columns of the sub sheets appear. We're having vendors update the sub sheets, and when they do this, their inputs are linked to our internal master sheet. What I want to do is EASILY set up multiple (and numerous) cell links…
-
Default sorting of attachments
Good afternoon, Is there a way to set the default sort for attachments? Currently it is by date and we'd like the default to be by name. Blessings, Loann
-
Salesforce ServiceCloud Users/Connections
Hi Smartsheet Community, We're thinking of some use cases for helping Smartsheet users utilize Salesforce ServiceCloud data more effectively and efficiently. Any Salesforce ServiceCloud users out there who would be willing to chat with us and give us feedback on our use cases? Even if you don't use ServiceCloud but know…
-
Workarounds for Smartsheet's lack of support for effort driven tasks?
I know that users have been clamoring for this shortcoming (the lack of support for effort driven tasks) to be addressed since 2015, but this is the first time that it's been a must-have for one of my clients since I began using Smartsheet in 2013. Here’s an attempt to describe what I need to accomplish: My client's team…
-
GMAIL and Smartsheet Integration
Good afternoon Is there a reason why we are not able to fill out some of our columns on the Samrthseet Side bar ? It says "Please edit the following columns in Smartsheet" which requires an added step....... Thank you
-
Setting chart colors before all options have values.
Hi, I am trying to show a series of data statuses. Currently, all of the status are "Open" (work has not started). I have all of the options selected as data for the chart, but SmartSheet does not allow me to assign a color until the values are greater than "0". Is there any way I can preset these colors so that when the…
-
COUNTIFS Formula
I'm having a hard time figuring out the formula to use if I have a column of dates and I want to count how many cells fall between a date range. I have tried the following formula and the results came back with 0, however I know there there are 7 cells in the column that fall under the date range. =COUNTIFS(Date2:Date73,…