-
Need local time based on City & State
I am building a solution whereby I need the local time based on City and State. This is a lookup sheet whereby a store # is input and formulas return address, phone # and contact. I need to include the local time as well. For instance if store is located in Dallas TX then I need local time in Dallas TX. However, if store…
-
Add a "Today" button in Calendar view
I would love to see an option to be able to quickly navigate to the current date in the calendar view. Every other platform with a calendar I've used (Outlook, iOS, Airtable, etc.) has a "Today" button that will immediately navigate you to the current date. I already find that Smartsheet calendar view does not always open…
-
Automation to Combine Multiple Row Attachments into a Single PDF
I’d love to see a feature or automation added to Smartsheet that allows users to automatically combine multiple PDF attachments into a single PDF. Use Case: I have a Smartsheet where we collect applications, and each application includes several supporting documents uploaded as individual row-level PDF attachments. When…
-
Task Status Update based on Previous Step Completion
I've been asked to lock the "Status" column and only allow changes to the "% Complete" field by the assigned task owners. This admittedly will limit the use of all the status' as I'm trying to develop a strategy to simply change my approach and limit the functionality options. My Status column should ideally include the…
-
HELP! Move Row Automation
I created a "move row to another sheet" automation where the trigger is when rows are changed and ACTIVE / INACTIVE status changes to INACTIVE. When I changed the status in one row, the automation was triggered and now all of my rows are gone, and they are not on the destination sheet either. Where is my data? There is no…
-
=LARGE Formula Question
Alright Smartsheet gurus, I need a hand! I am familiar with the LARGE function and how to use it to identify the highest numerical values in a column. However, what I am trying to accomplish is to feed that data into a dashboard that identifies those values' corresponding categories. For example: Location1 100 Location 2…
-
Stack multiple saved filters
It would be helpful to be able to "stack" multiple saved filters, so that a user could apply multiple, orthogonal criteria at once without having to create a cross product of defined filters. For example, if records can be either "current" or "past" and either "material" or "immaterial," a user might want to search for…
-
Assign in rotation
I have a sheet, and need to add an "assign to column", and would like to auto assign each line to one of four people in a rotation. So, submission one goes to the first name, submission 2 goes to the second, submission 3 goes to the third, submission 4 goes to the fourth, and then the cycle repeats with submission 5 going…
-
Move worksheet to a workspace
Is there a way to move an existing sheet to an existing workspace?
-
Video Editing Software Discussion in Smartsheet Community
Hello Smartsheet Community, I wanted to kick off a discussion about video editing software, and how it can complement our project management efforts in Smartsheet. Here are a few topics to consider: Favorite Software: What video editing tools do you use? How do they integrate with your projects in Smartsheet? Tips and…