-
Finding Data in 2 Columns
Hi, I am having trouble finding data that meets certain criteria across 2 columns. I have several status's that have "In Process" included in the column "Status". I also have a column named "Priority" with several priority levels. I need to find how many cells have "Low" in the Priority column AND have "In Process" in the…
-
Left panel menu
I liked the tabs on top of the sheets. I could put them in whatever order works for me. I don't mind the "left panel menu" that we now have instead - but I DO NEED to put the list of sheets in the order that makes sense for me! Every time I need to open a different sheet, I have to scan up and down the list of 20 sheets,…
-
Copy / Paste to e-mail, word, etc
Hello all, Me and my colleagues are facing one problem while copying content from the smartsheet to an e-mail (outlook). I've attached 2 ss where in the first picture you can see what I would like to copy and second picture where the content being pasted into the e-mail. As you can see content loosing its border lines. Is…
-
Dynamic Publishing - is it possible?
Hello, We have been using Smartsheet for a while but mainly to assist with our project management tasks and I am pretty much a very basic user in terms of skill level. However, we have a new requirement and exploring to see if this is something that we can use Smartsheet as well. We are looking to move our gifts registry…
-
Recurring task with task results stored per row
Good morning all I have created a grid for 'preventative maintenance' program - whereby the grid shows the task, owned by, frequency (daily/weekly/monthly etc), date last completed (user enters this each time they complete the task) and date next due is calculated (from the date last completed). But - my gap is that i also…
-
Conditional formatting
Hello All, I am facing one problem with Conditional formatting. I've chosen one format to be applied if specific team is selected (in this case MW). The problem is that in most cases text color is white as I want to, but in couple rows the formatting doesn't work properly as it changes cell color but doesn't change text…
-
New Modern Form
Not sure when it got added. But, the new Modern Form looks amazing! Great job! I hope one day we can use further formatting such as HTML in the description. Or even allow us to force field validation. This is an amazing step forward I like it!
-
Summing up child row cells to parent rows
I have reported production numbers and I have shipments going out. I want to take the production number and subtract it from the shipped # and give me a remaining QTY. When logistics moves more of the product they will add a row for the second shipment and make it the child to the first shipment. I would like the qty from…
-
Identifing rows based on multiple form sources
We have a form which is sent to customers to register their commercial contact details. The customer doesn't always know which product they are receiving so this is added to a sheet column after population. However, a new row triggers notifications to various internal stakeholders and they receive this notification before…
-
Unable To Change Workflow Option To Run Hourly.
Hello, Is there a reason why my workflow will not save when I select to run it "Hourly"? The only option that works is "When Triggered". There is nothing that is telling my I need to add information (no red boxes). I click save and nothing happens.
