Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
I am new to using Dynamic View. I have three sheets that I combined into a row report and then have been trying to create my view off of that report. I have a column named request type on all three sheets and each sheets has different drop down options for that request type column. When I go to do conditional formatting the drop down options only show for one of the sheets instead of all three. How can I get all three options to show for conditional formatting? Thanks!
Hi @Cassandra Pearce
I changed my approach and used all the requests in one but used helper columns to show what I needed.
When you use a report but want to add something or change something it is accessing the original sheet - you can test this for yourself by choosing the option add new .
Might be easier to show you how I made this work - I am attaching an image below.
Let me know if you want to catch up on a quick zoom call so I can explain it.
I am using Logic to show me the fields that I need so I can add to the bottom of the list and then the key columns use if statements depending on the category type to pull the data through.
Kind regards
Purnima
I created an extensive automation to gather approvals on a change request. In the customized message I am referencing some fields. Some fields are dropdowns and other s are just contacts. However, when the message comes through, those fields are not populating any information. I have looked at my column names and they…
Hi everyone! I was wondering if anyone knows a way to attach a file upload space to an update request. I have already set up a workflow to send out a update request at the appropriate time but I cannot find a way to add an upload space. I know that I can add attachment when I manually send update requests, but I was…
Good afternoon, The current account holder is no longer employed with Ambipar. We need to have the primary account contact and ownership transferred from that individual to me. Could you please provide the contact information for a Smartsheet representative who can assist with this transition, or advise on the process…
