-
Bulk download of all the PDF attachments in a worksheet
Hello Community, I am quite new to the Smartsheet and came here to get some advice from you all, i would like to know if there is a way to download all the PDFs attached in different rows of worksheet at one go if the attachments are more than 1000, it would be very helpful if you can guide me through the process, i am a…
-
Help me out with Groupings Please
Help me out guys I'm dying here trying to get a way round this. I need to group this report by month. But as you can see I thought easy I will bring in the month and year. But it lists it in Alphabetical. Doing this by Start Date is nice but would prefer per month. Please Help 🙏
-
Default values in Columns
Hello all. We have a Sheet and sometimes users forget to add important fields. We want to add default values to these fields in order to not be empty. The types of columns that need to have default values are: Text/Number, Contact List, Dropdown List. We have tried a way to add default values with workflows on Dropdown…
-
How to show Contact Names instead of email addresses in Contact Column in Sheet?
Hello all. I am using Contact Columns in my Sheet, where we add Contacts. There are two ways to add a row: either by submitting a form, either by inserting a row inside the Sheet. The problem is that often only the person's email is visible while we want to show the person's name. From my research I found that you have to…
-
Unable to edit dashboard with Admin rights
Hello all, I have added a user as an admin for a dashboard but she is unable to see the edit (pencil) button. Tried adding her as admin in the workspace but still doesn't work. Any idea? We are on Enterprise plan. Thank you.
-
Group & User Management - Sorting of Members
Hi I have 2 questions regarding Group Management... Does anyone know if it's possible to sort the Members alphabetically please? Even though they were imported in alphabetical order, when I open the group the list is randomly sorted. Not helpful when you're trying to search for a user within a list of 100 people. Is there…
-
Forms - Heading/Description
Is there a way to apply formatting to a Heading / Description field in a form? In the Description area, it looks like you can apply formatting (Bold, Underline, font color, backgroung, etc...) However, when I change these values, I don't see where this is reflected on any of the fields. As you can see in the screen shot…
-
And If formulas with date ranges
Hello, I am reaching out to the community for assistance. I am trying to do a date range formula. This following works: =IF(ISBLANK([74. Discharge date]@row), "No Discharge", IF([CRM 30 Day Done]@row = 1, "OK", IF([74. Discharge date]@row > TODAY(+15), "", IF([74. Discharge date]@row < TODAY(+31), "Past Due")))) This is…
-
Gantt colors and Dashboards - is there an easier way for my issue?
The issue I'm having is that I'm creating a milestone dashboard with gantt view, but need to be able to change the colors of the gantt chart, which can only be done in the grid sheet. Smartsheets does not allow for changing the gantt colors of lines that are considered headers, subheaders, etc. Only task lines. So now I'm…
-
Can I add an attachment to a row once it's locked?
I have a lock row workflow set up to lock when a specific date is met. We came across a situation where an editor needs to add an attachment after the row is locked, but can't. Is there a way for editors to add attachment after a row is locked?
