Sign in to join the conversation:
Since I can't mask/apply sufficient conditional formatting to highlight a improper SS, I've parced it out into various columns and then was applying CF to each particular column. However, when applying CF to the row it doesn't see the 'number' as it's actually a calculation… Is there a way for it to focus on the cell contents rather than the VARCHAR? (e.g., for SS Prefix, the conditional formatting would read 'IF SS Prefix is <100 OR >999 OR not a number the apply this format to the Social Security Number' For some reason, it's not seeing 548 I believe it's seeing the formula that is producing the 548 '=MID([Social Security Number]@row, 1, 3)' Is there a better way to have it focus on the 548 that's in that cell??
Is it possible to auto-populate an email domain in a field where people are asked to enter their email address? For example, I would like users to only have to type their name, without needing to enter anything after the “@” symbol, to reduce the chance of personal email addresses being entered.
This discussion was created from comments split from: I am an editor on a smartsheet but can't edit the sheet.
Good afternoon! My company works closely with another ambulance service, Company B. Both companies have a Smartsheet Enterprise plan. I have created a workspace that I need members of Company B to edit. Do I need to make them members on my account if they are already members on their account? Or do I just need to add their…
