-
Automatic sorting
i have a sheet that has data with dates added from a form. it always adds a new request from the form to the top and i have to manually sort it by date in descending. is there not a way to have it automatically add the data by the date in descending order?
-
Stop autoformat to a percent
Hello, I have a form that collects information on a person's effort on a certain project. The field is left open & not restricted to a certain value as it depend on the person/project what is best to enter. The issue is that Smartsheet takes some of the values & multiples by 100 so that I get 100% to 500% showing often,…
-
How many would be interested in more visual customization in sheets?
A primary use case for Smartsheet for my department currently is what we call Selection and Segmentation. Essentially we crunch a bunch of data about influencers in a particular field and match this data to the goal of a company we consult for. We then suggest a pool of candidates for the company to focus their efforts on…
-
New Templates?
Hi Smartsheets Crew; I wanted to know if you guys are going to create any NEW Templates in your Solution Area OR 🤔 If you plan on ENHANCING / ADDING to your EXISTING ones (to utilize any/all recent changes to the software) since the Template(s) was launched? 😁 It would be great to see some fresh new ideas that relate to…
-
Report showing Item entered Fail, but not Pass
Hello all, First time posting here. I'm using forms to populate sheets with data on quality inspections processed. I'm looking for a way to create an ongoing, active report of units (which are identified uniquely with a serial number) that are awaiting fixes. Currently I submit a form for the initial "Fail", then submit a…
-
Pasted text from OneNote to Smartsheet cell appears as an image?!
Hi, When you paste text from OneNote into a cell in Smartsheet it appears as an image. This is so annoying. See attachment. The only workaround is to paste the text into a web browser or word document, then copy/paste that back into Smartsheet cell. This is affecting our use case somewhat, as often in project meetings our…
-
Change Status Based on Previous Row
I am trying to create a column formula that will change the status of a row to "Ready for Work" when status in the row above it changes to "Complete" I tried to follow the information that was provided this thread, but I keep getting #UNPARSEABLE:…
-
Hiding or deleting content via Automations
I have multiple sheets following a complex workflow. When some of my workflows are completed and moved to the next step in the process, I want the row of information on a sheet to be automatically hidden or deleted. I see that we have delete a column, but not a row. I need my row to be cleared after the data has already…
-
Sheet summary report not showing all columns
So i was trying to edit a sheet summary report that was built from someone prior to me and i was struggling to make the necessary changes so ive made a new summary report, however, i am running into the same issues. For some reason the column options in the sheet summary report are not all of the options that should be…
-
Matrix Sheet based on date and personal resource assigned
Hello all I'm a bit stumped by this and would like assistance on how to create my formulas. I'm tasked to create a sheet, view, or dashboard to summary our master data sheet turning it into a matrix style sheet. This matrix style sheet will pull data from several other databases within smartsheets. The matrix should…