When I enter in my email address, it changes to a name format. I am trying to Index/Match it to another sheet and it doesn't recognize it unless it stays in the email format. How can I set up to not convert?
The email address is changing because the column type is "Contact List". You have two choices:
The Contact List field has some special functionality you may want to keep, if so choose #2 above. If you don't want the new column showing email to show up you can always hide it. A hidden column will still work with filters on reports or queries.
I hope this helps.
Thank you. I was able to use option 2 and it seems to be working.
Hello, I have been attempting to use the IF/AND statement with my status balls with no luck. Here are my conditions: Green = Outreach Date <15days & Go-live is blank Yellow= Outreach Date > 15 days & Go-live is blank Red = Outreach Date > 30 days & Go-live is <Today I am needing them all in one formula for my status ball…
I have provided a dynamic view for my users to see content on-screen. However, I've been asked to provide a print option as well. Normally, I would export a report to PDF for 'clean' printing [that is, preserves layout and colours with pretty explanatory note in header]. However, I don't want my users to have access to the…
I would like one of my worksheets (product development tracker ) to be visible in a widget on my dashboard, I have a URL link to it but I actually want it to appear at the bottom of my dashboard, so I can see it without using the link, can this be done ?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.