-
Exporting Smartsheet formulas
From my research, I understand there isn't a way to keep formulas when exporting from Smartsheet into an Excel document. I have a total of 50 columns with formulas and would think there was a quicker way to grab the formulas. So far, I've appended a "!" which turns the formula into text which does export. However, I'm not…
-
Difference between managed and unmanaged resource in Resource management
Hello everyone, I’ve recently started to use Resource management in Smartshet and I’m still learning how to fully take advantage of its functionalities. I have a few questions, because som things are bit unclear for me and I hope that community can help me. I understand that there are three types of users in resource…
-
I am getting an error message when attempting to export to excel
I am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
-
Auto lock a cell after data is entered
Is there a way to automatically lock a column after data is entered?
-
All fields on the Smartsheet form is showing despite logic being applied to all.
Hello Everyone, So I built a form a couple of months back which was working fine with logic applied to it, but suddenly today when I opened the form, I saw all the fields are shown right from the start which should not be the case. Originally the form should only show the Full Name Email Department Request: On the basis of…
-
Is there a way to identify and highlight that a particular contact has overlapping dates?
Staff assignment sheet I want to be able to highlight rows that have the same person assigned to overlapping dates. Assignment is a Contact list dropdown and the dates is a Date column.
-
Columns unhidden on their own
Hi, I've had a certain sheet active since October 2023, but in the last month, certain columns that I normally have hidden have been becoming unhidden, seemingly on their own. I re-hide them, then the next time I go in, they're unhidden again. Here are some entries on the activity log - none of these people have licenses…
-
Form fields to include Comments
It would be really great if, in the manage forms section, form builders are able to insert a comments field that would populate as a comment on the row once the form is submitted. I have searched many product ideas and did not see this, but I did find older conversations in the community stating that it would be desirable.…
-
Formatting of Automated email text
I use a lot of automations that send customised email to contacts. These often contain instructions and multiple paragraphs of text. I find the 5 line box very restricting and hard to navigate and view my text to make sure it is accurate. I would also love to be able to have some formatting, such as bullet points, bold,…
-
Meet Sam Harwart, our November Member Spotlight! 🎉
I have a lot to be grateful for when it comes to our Community members, especially today because I get to tell you about our November Member Spotlight! A man of many hats, @Sam_Harwart is a certified Smartsheet Partner and Community Champion, so you know this is going to be a great read. Sam is the Managing Director and…