Sign in to join the conversation:
I want to share a sheet with someone in my company. She is unable to access the sheets after I share them with her. Our only thought is because she has an apostrophe in her email adress. Has anyone encountered this and is there a work around?
Hi Tracy,
If I'm not mistaken it's not possible to use special characters in an email address so that could be the reason it's not working.
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
I think I'm having the same issue. My user has an apostrophe in their email address but also has an alias for a non-apostrophe version. I feel like the (log in with Microsoft) Entra authentication process is defaulting to use the non-apostrophe version.
I can't add the apostrophe version to the account as it says it's already in use, which I'm guessing means Smartsheet doesn't recognise the difference in the addresses. I also know for sure it's not used for another smartsheet account. This is frustrating.
Has anyone figured out a way to use a column as a created date but not have the time stamp? It causes problems for my manager trying to use that date to pull into PBI. I know how to convert in a helper column to a year-month and a year, but those have to be text/number columns, not date columns and he can't use those…
I am looking for a way to automate a cell so that when column A displays 9 'Days Open' (or between the values 0-14) the 'Req Age' will auto populate (or trigger) the ranges provided. Image below: I want the highlighted section to auto populate based on the value in 'Days Open'
Good morning, I haven't needed to do this is quit a while but I went to clean up the "Sheets" folder in my account and can no longer create a folder, sheet, or report in any area of that folder. The "Create" button at the top right takes me the templates page. This is what I am seeing vs what I can do within a workspace.…
