I have a form that auto assigns when a new record is created. The sheet allows multiple contacts to be assigned - however, I can only select 1 in the "default" value....
Have you enabled the "Allow multiple contacts per cell" option?
You would need to know what the delimiter is that Smartsheet uses when separating out contacts. Otherwise even enabling multiple contacts per cell won't work.
There may be a workaround though. Can you explain your process in more detail?
You say "Default value". Does the person submitting the form change this at times? If so, do they need to be able to enter multiple emails? Is it necessary to use emails, or would it work if you entered "John Doe", and his email was populated by a formula on the sheet?
yes - however in the form, users are only able to select 1 in the drop down of contacts.
Have you added all of the contact names under Values in the Contact Column in the sheet?
This bug still exists. you can only have 1 default notification person.
Hi everyone, My boss is bringing data in from my Smartsheets into PBI. He is having issues with the dollar value columns showing up as text instead of dollars. There is no option for the column except for text/number. What can I do to solve this problem? Thanks! Freda
I have a project tracking sheet that is updated weekly with the most recent updates for project progress, issues/concerns, barriers requiring intervention and next steps. How can I display only the most recent updates for these 4 columns in a dashboard?
How do I make a dashboard available so that anyone can access it without having to login?
