-
JOINING Contacts from Children rows to Parent
Hi. I have active contacts from my contact list in Children row. I would like to bring them together in one cell in parent row. I understand function COLLECT needs to be used with another function. If it is JOIN, then it lists me all the names but they are not active contacts anymore. Is there a possibility to keep them…
-
User permissions
Dear Smartsheet Community, I am turning to you because I am having an issue that I am not able to resolve. I tried to ask smartsheet directly but they haven't answered yet. I do hope you can help me. I am a licensed user (pro) and I collaborate with many other consultants (mainly free users, some pro as well). On my…
-
Formula for years and months between two dates - three dates
Hey Smartsheet! This is regarding service/employment time for employees and I want it in years and months. Right now we have one that works for just years and that formula is: =IF(DATE(YEAR(TODAY()), MONTH([Start Date]33), DAY([Start Date]33)) < TODAY(), YEAR(TODAY()) - YEAR([Start Date]33), YEAR(TODAY()) - YEAR([Start…
-
Return multiple email addresses defined by role
Hello, I want to notify people through an automated workflow. The notification should be sent to persons related to a certain role and the role-name list is stored in a separate sheet. There can be a single name or multiple names. How can I join contact values, so the joined values will give email addresses? The join…
-
Access issues in both logging in and opening certain sheets
I've been experiencing issues where Smartsheet isn't loading, giving an error: Due to network connectivity or feature updates, Smartsheet is experiencing slow loading times. When smartsheet eventually opens up, I get another error on a specific sheet: Your request has resulted in the following system messages: <blank>.…
-
Automated workflows with reference data from other sheets
I have a master worksheet with a Status column that defaults to "Submitted" for new records. Behind the master worksheet are a few sub worksheets for specific processes, along with their own status columns. In the master worksheet there are reference links for the status columns of the sub worksheets. I would like to…
-
PMO template questions
I’m relatively new to Smartsheet, and I’m trying to use the PMO template as the basis of my design, but I have a couple of questions: 1) I see other posts on this Community talking about the step-by-step instructions for the PMO template, but I can’t locate those instructions. Can someone point me in the right direction?…
-
Adding colour
Is there any way to change the column name cell colour or even the text colour? I want to use the sheet as a tracker and I would like to make the entry fields for users easily identifiable with a different colour. I don't particularly like the look of having a colour applied to the full column. If this is not possible, any…
-
Selecting a sheet reference from dashboard, report or another sheet
Every time I need to select a smartsheet item from another item (report for the dashboard, item for widget behavior, item in the dashboard shortcut, a source for a report, or a hyperlink to another sheet), the item selection begins from the top Sheets folder. Is it possible to configure that dialog (I am trying to look for…
-
Can this possibly be true - that Smartsheet doesn't have column validation for numbers?
I'm sat here flabbergasted. Can it possibly be true that Smartsheet doesn't enable you to natively enforce simple validation rules such as: a) Entry being a number b) Being between 2 values Really? I'm baffled by this. Surely the devs would have realised this is an essential feature on DAY 1? I can only assume they are…