-
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…
-
Control Center - Global Update for Conditional Formatting
We would love to have the capability to push new conditional formatting using global update for provisioned project sheets. We have over 200 projects and whenever we get new ask for new conditional formatting (since things change all the time), it's a huge manual hours to go through and update each provisioned project with…
-
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…
-
Showing multiple dates from the same sheet row in a calendar
I have 6 columns in my Smartsheet that are date columns, two of which are start and end dates. I have got the start and end dates to appear in a calendar report, but the other ones (individual dates, not date ranges) do not show up. I cannot have them as children rows. I have tried applying conditional formatting to the…
-
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…
-
Date & Timestamp a specific cell change
Hello, I am very new to Smartsheet and I am working on a project tracking sheet. We have the following statuses in a cell: Unassigned; In Progress; Completed; Cancelled; On Hold When a request is submitted this automatically triggers a 'Created Date' column that logs the date/time of creation. I would like this to be…