When I use a contact list in a pivot the email address is returned, I'd like to see the name so I can use the Pivot in reports and show the name, not an email address. Is this possible?
Hi Andrea,
At this time, the Pivot App will always pull the email address out of a contact list column. I believe it's set up this way because of how Alerts work.
When you have a moment, please submit a Product Enhancement Request to let our Product team know that you'd like to have this functionality within the Pivot App.
Hey Everyone, is there a way to force when they update a cell in one column ( in this case Status), they must also update the Assigned To column before they save?
Hi everyone, I have a formula in my Smartsheet that shows 5 workdays from the submission date. I have an automation setup to send a reminder to the Quality Engineers when a date is reached. Is there a way to be specific, such as when the 5 Day Reminder date is reached, where the condition is that the complaint is open? I…
I have a Sheet Summary Report that pulls data from 48 individual sheets — this includes both the row-level grid data and each sheet’s Sheet Summary fields. I want to have all of this information (both grid and summary data) together in a regular grid sheet, so I can format it, add formulas, and use it in dashboards more…