My CEO continually interjects his own agenda into the company's workflow. It's been a challenge for many years, and we all know that he won't change. So knowing that we, as a company, cannot tell him to stop, I would like to create some visual that will show how his interruptions cause delays in deliverables of other…
To share back with the community here, I'd like to share some key formulas that I've been helped with by the community and extensive testing/fixing. I have a sheet that tracks: * progress for items based on user inputs of %age complete * compared to the progress they should have completed so far (%age expected as of the…
Hi, Is there anyway to sort columns by fill color or text color? When we need to draw attention to certain items in Smartsheet In Excel we use color coding to sort. That ensures that the specific criteria requested will be presented on the top...(not all the criteria are the same ex. by date, so conditional formatting…
is there an ability to set a conditional format based on two columns in the same row: completed (column) date is later than the due (column) date – the cell turns red completed date entered is before (or after) today's date
Is it possible to create a chart without including the hidden data?
Hello, I have used Smartsheet for some time now, but just started investigating using Card view. Unfortunately, Card view cannot be used on a report. Previously I had a report that combined my personal tasks as a manager from one sheet with tasks from my involvement in projects my employees are working on to create my…
Is this a Bug? I've set my report to display rows where %complete is "less than 100 or is blank" but the report continues to pull rows that are set to 100. This behaviour seems to be consistent in all my sheets, including this brand new one I created from a template!
How can I move completed taks to other location in the same sheet ? I have three different lists on one sheet: completed, active, not completed (as outdent and indent positions). How can I move completed tasks to required list ?
Hello, I am trying to build a Report or ANOTHER sheet where I pull data only for Rows from another sheet that have OrderNr=OrderNr from the other sheet. The ordernumbers change daily. I need to be able to refresh automatically on a daily basis. Any recommendations how I should approach this?
Hi, Are there any limits to the number of dasboard a user can create? Many thanks, Grace
