could you please suggest below view possible or not in smartsheet. based on below conditions .
Hi @Yashwant Singh
I'm not quite sure I understand what you mean. Are you looking to change the colour of the task bar in a Gantt chart view, based on whether or not something was completed on time? If so, you can set up different Conditional Formatting rules (see here) that change the bar based on certain criteria:
The drop-down arrow next to each rule allows you to add a condition (ex. that the End Date is in the future and that the Processed column says "yes"). Then for the format, you'll want to change the task bar colour. More information on changing the task bar colour can be found in our Help Center (see here).
Hope that helps!
Hi all. I am new to Smartsheet and I am building my first form. Is there a way to set up a form to show additional fields that will only appear after it is submitted? These new fields will be filled out by someone other than the person who submitted the form. They will be viewing this in the card view. Thanks for any help!
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.