-
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?
-
Merged: Conditionally Lock a Cell in a Sheet
This discussion has been merged.
-
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?
-
Trying to Auto-update due dates based on actual completion date
Hi, I am new to smartsheet and I am finding it very useful; except that I can't figure out how to auto-update completion dates. For example, when I plan out my project, I put start dates, duration, predecessors and who it's assigned to so I know when the project should be done. Building a house may require someone to build…
-
Is there a way to mass edit the color of an item in the calendar view of a sheet?
I'm creating a calendar with all the different tasks our leaders need to do each year. Is there a way for me to color coordinate so each task is the same color every month without going one by one? The screenshot below shows how you can do it for one item but that's too tedious. I've tried conditional formatting but that…
-
Conditional Formatting comparing two dates
I'd like to create a conditioning formatting to highlight a cell based on the difference between two dates. Column A is the expected date of delivery. Let's say 1/1/23. Column B is the actual date I received it, say 1/5/23. I'd like it to follow this rule: Highlight Column A cell when: Received date is more than 5 days…