-
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…
-
Subtract Invoice amount from Total based on Status, in Parent-Child relationship
Hi all, I am new to create sheets, but I am trying to create a solution to track forecasted invoices that need to be sent out. I want to put each invoice total separately and when the status is marked as "Complete" I would like to have it subtracted from the Contract Amount to show the Contract Balance. I set it up so the…
-
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…
-
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: I already have an auto-number column (Job # - font is just in white based on…
-
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…
-
Merged: Capability to add more than one column at a time
This discussion has been merged.