-
How to clear a cell when a box is checked - using automation
Hello, I have a reporting task list that shows days until due and days past due based on todays date. I also have a box that they can check once the task is completed. I am wanting the days past due and past until due column to clear once the box is checked. I tried doing this with an automation but it didnt work so i…
-
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?
-
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…
-
Cleaning External email list
I am wondering, is any other organization is working on cleaning the External email list in Smartsheet. If yes then how and what are the steps need to taken to do this task. We have around 1500 emails added over past 2 years it's high time for us to recertify/ Clean the External email list in Smartsheet
-
Organizing Smartsheets into folders - Impact to DVs and WorkApps
Hello, I'm trying to organize the workspace listing in Smartsheet. If I create folders and move sheets into different folders, will that mess anything up for the Dynamic Views and WorkApp? Thanks, Frank
-
Automation to send past due notifications to members
Hi All! I hope someone can help me create a (functioning!) automation. I need Smarsheets to send a daily notification to task owners, if the task is marked past due. Currently, I have been able to create an automation that will alert owners when a task becomes past due; however, this is a one-time notification. I've…
-
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…
-
Calendar App vs. Published Calendar View
Our support team is trying to publish a calendar and allow customers to click on the time slots for and enter their information to book a training. I have the sheet and the automation working well (formulas, automation, etc.). This all seems to work in Calendar view, but the saving and all gets a little weird, and the look…
-
Constraining a deadline that has predecessors
Since Smartsheet does not have constraints built into the scheduling software, I have trouble with drifting deadlines. A proper schedule has predecessors and dependencies assigned to tasks and this string of links needs to logically end with the deadline. The problem is that as soon as someone makes an adjustment to a…
-
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…