-
Count Multiple Cells If Multiple Conditions with Date
Hello! I am working on linking a database to a results sheet and I need several metrics pulled out. I have Supplier, Defect Column 1, Defect Column 2, Defect Column 3, and date. What I ultimately need to do is create a January through December count of defects per Supplier. So I have Jan, Feb, Mar, ... Dec. on one axis,…
-
Tracking Progress
Is there a solution that can be shared to assist me in sharing progress at intervals? For examples, I have a dashboard that lists the projects and the % completion, at any given time. I would like to have that dashboard, show (let's say) % complete on 12/31/18 then % complete on 1/31 etc. There is a need (want) in our…
-
Form Search and Auto-populate values
Hello, I have the following project I would like to achieve in Smartsheet if possible. I have a master data sheet with information hard coded. The sheet has a key reference number associated with each assigned task. When a user wants to add a task into the master sheet, they have to open the form and enter a key reference…
-
Merge & Center
Hello, The "merge & center" is a formatting option I am quite fond of inside excel and curious if I can replicate this in SmartSheet. I would welcome any feedback. Sincerely, Scott
-
Time with fractional seconds
Good morning, I am using Smartsheet to track swim time which has a format of minutes:seconds:fractionalseconds (i.e. 5:00.50). I would like to see if anyone has a solution for a couple of issues I am seeing: 1. I would like to use the MIN function to look across multiple cells (swim meets) and pull the minimum for the…
-
Automating the Formatting of Cell Hierarchy
Is there a way to automate the formating of your parent and child rows? If I have 4 layers of heiarchy (h1 > h2 > h3 > h4), is there a way smartsheet can automatically formate each layer of heiarchy? For instance, telling smartsheet to make the top parent rows (h1) BOLD at 16pt font while making all h4 child rows…
-
Comments column on web form
I am looking to create a webform that has the comments section. Now from what I have read thus far, it seems impossible to do. That if you want a free flow text field, you need a new column and have it as such: comments. However, some comments can be extensive. And if you wrap teh text, teh smartsheet becomes out of whack.…
-
Advanced Calendar App - Contact List
Hello, Just wanted to get some feedback regarding changing "contact list" fields in the Advanced Calendar Application. When i am editing "contact list" fields (such as a users name) directly in the advanced Calendar App, then press the "update" button so the information is updated in the related Smartsheets, i am getting…
-
Extracting all instances of a word from a text string and creating a list in a separate cell
Hello all, I have been pouring through excel and smartsheet help forums for a couple of days now, and I haven't seen my issue asked or addressed so thought I'd ask here. I have, in one column called Terms, cells that contains lists of terms and phrases. For example, one cell contains the following text string:…
-
Change height of the column title (top) row
Is there a way to change the height of the column name row? Some of the column names are longer and I want to be able to wrap the column name. Appreciate your help.