-
Unable to access Reports
Our team is unable to access reports. They won't load and end with an error. Is anyone else having this issue at the moment? I have been adding conditional formatting to some sheets today. Is that known to cause errors with reporting?
-
If updates are made to one smartsheet, can it be ported to another?
I have two smart sheets that are almost identical(one is a copy of the other - except I removed 3 columns). I am looking for a functionality such that if updates are made to one, the second smartsheet gets updated automatically! The reason for two smartsheets and updates is because the audience for both the files is…
-
Selecting Rows for conditional formatting
Hi, I have put some conditional formatting on my sheet. But there are certain rows I don't want it to apply to. Does anyone know how you can exempt particular rows/cells from formatting? Thanks
-
Count values that are not formatted with Strikethrough
Hello - - I am trying to count the number rows in a column that do not have strikethrough applied to them. Is there anyway to use a formula to determine if a cell value has been formatted with strikethrough? Thanks,
-
Spreadsheet Filters vs Report Filters
I have a text column that has formulas and conditional formatting already added to it preventing me from changing the column type to a dropdown list. It is spread across several years of spreadsheets making a larger conversion to a list time consuming. I have a request for Report Filters to have the drop down list similar…
-
How to hide rows on a list?
Hello everyone, I am on the trial version, testing to see if it will work for my company. I loaded a spreadsheet from Google Sheet, and I am trying to hide some rows. I clicked everywhere and wasn't able to find. Would somebody please help me? Super thanks in advance!
-
If this then that
Does Smartsheet have the ability to move rows to a new sheet based on a condition being completed? An example would be if you have multiple projects (rows) on one sheet and want them to be moved to a new sheet when the status is changed to complete. Is that possible?
-
Automatic Formatting: Summary / Parent Task
Good Day All: Is their a way to add a condition for summary task? For example, the condition would be to bold the Task Column if the Task is a Parent / Summary Task. Thanks
-
Alerts not Sending to Assigned To Column
I want to send a daily reminder listing open tasks to contacts listed in my Assigned To column. All contacts have been shared to the sheet as Editor - cannot share. At least a couple of these contacts are users who have used SmartSheet before. I set a conditional formula in a reminder date field to populate with today's…
-
Conditional Formatting
Is there a way to add a conditional format to a cell that has a drop down RYG...like project health? If a task date is past due, I want the health cell to change from green to yellow automatically. Thanks for any help!