-
Highlight duplicate entries
Hello, We are using Smartsheet to track payables and would like some sort of conditional formatting or formula to alert us if an invoice number is a duplicate on the same sheet. Is there a way to do this? Similarly, could we use a formula to look to other sheets as well? Or are formulas self contained within each sheet?…
-
Forms Help!
So I know that there is no way to align submissions with specific cells, but has anyone found a creative workaround for this that still allows you to identify the submission with proper trigger data?
-
Color code drop-down lists in calendar view
Hi all, I am new to Smartsheet and I hope you can help me with a question. This is my current sheet set up to keep track of the events organised by my team organised by country. Each country is a Parent row and child rows are the events' names. I would like to format it in such a way that if the parent row is color coded…
-
Drop Down List not populating (Mobile Version)
Hello i have a quick question and was wondering if anyone was experiencing similar issues and have found a work around. I put together a checklist for our MHE and would like to post a QR code to the Smartsheet around our facility. The issue i am experiencing is one of my columns with a drop down box is not populating on a…
-
How to make tasks health status column more accessible by include color words
Hello, I am trying to make the health status column more accessible by including words to match the colors (e.g. 🟢 green, 🟡 yellow, 🔴 red). Does anyone know how to do this?
-
Conditionally Lock a Cell in a Sheet
Apply a feature to conditionally lock a cell in a sheet when one or more criteria are met.
-
How do I count the reason for the consult, AND the year it took place?
I tried to amend this formula to report by year. Below is the formula I tried, which didn't work. The reasons are part of a drop down on another sheet. The consult date is on the same sheet, but the full date is in the cell, 10/12/2017, 11/1/2017, etc. My current formula in the TOTALS to DATE is: =COUNTIF({Reason for…
-
How to pull data from another sheet based on a specific criteria
Hello, I have one sheet that includes all of our projects listed in rows and I need to create specific sheets outlining the tasks for each of the rows. The new sheet should also include specific data (such as dates, names, etc.) from the first sheet. I'd like to be able to link data from specific cells from that first…
-
Format report as a form; export to Word
I would like to be able to use SS as a repository for data that can then be output through a form and imported into a Word document as formatted text, using Word style assignments.
-
Is it possible to conditionally format the colors on a bar chart?
I am tracking service level across clients. In the reports I get the formulas and conditional format to work but I can't get it to translate into my charts. Is it possible?
