-
Duplicate Conditional Formatting in New Columns
Good afternoon! Hoping someone has experienced this issue before. We have established a number of conditional formatting rules for 7 drop down selections in one column labeled Site "A". If we add a new column for Site "B" and Site "C", can those conditional formatting rules be copied from the Site "A" column without having…
-
How to indicate required cells to be filled in
Good day, I have different columns that does only pertain to certain rows. How can I highlight/indicate which cells are required to be filled out? Or can I lock cells which columns entry are not required for certain row items? I tried conditional formatting. It takes a while though. And there is only AND functions and not…
-
Annual School Operations Calendar
Can anyone recommend a format for an annual calendar for our school operations team? What I'm trying to create is a document to input all school activities for the year and plotting each department's tasks for each job. For example: School Open Day: events showing each department's tasks to achieve effective outcome. So…
-
Guidance on using Smartsheet to support PMO processes
I am about to move my PMO process to Smartsheet and am trying to figure out how best to structure this. Currently, we have a standard set of tools that we issue to a project manager when the project starts, this includes Scope, Business Requirements, Test Plans, Meeting Minutes, Issue/Decision/Risk Log, Project Plan etc..…
-
Combining a check box & date in one cell? Is this possible?
Does Smartsheet have the capabilities to include a date and a check box in one cell? or Several Checkboxes in one cell? Or Text and a Checkbox in one cell?
-
New update has broken reports, cell drop down lists are gone
As of this morning, dropdown lists no longer work in any of our reports, only the main sheet. This is a major problem...any ideas what's going on? Logged out and logged back in several times, but to no avail.
-
Report - max rows 500?
Morning, Can a smartsheet report only accomodate 500 rows? Is there a solution for >500 rows? Thanks.
-
Search the current report?
I know there is a way to constrain a search to the "current sheet". Is there a way to constrain a search to the current *report*. Thanks, Stan
-
Multi Project Milestone Report
I have a series of projects that I need to report out the End Date for each of the milestones and I'd like to do that in a table. So here is what I have. I have 7 projects, each with 7 Milestones, each with 1 dates. I laid those out in a report as 3 separate columns - Project, Milestone, Date. So what I need a table with…
-
Row print
I can't find a discussion that covers this: I know there's a way to print a single row with columns in vertical view, with the option to include hidden columns, but is there a way to automatically exclude printing blank columns? I have columns that don't apply to all rows, so when printing there are blank lines. I could…
