-
WorkApps Attachments Disabled
Has anyone seen this in WorkApps? Anyone know what's going on?
-
How to Sum a total excluding numbers before a "0"?
Hello, I am looking to add a formula where we rollover the total points each quarter if the quarter is greater than zero for the prior quarter and add only the total points documented after there is a zero listed for a quarter. For instance if someone receives points in Quarter 1, no points in Quarter 2, but has points in…
-
Filters and Formatting not Working
Suddenly our smartsheet has lost all filters and the conditional formatting doesn't seem to be working. It looks like nothing has changed to make this happen, but we don't know how to fix it. Any ideas?
-
Conditional Formatting Disappears When I Begin to Work in a Sheet
When I am enter into a sheet with conditional formatting I can see it applied. But if I search for something, or begin to scroll, or click into a cell the formatting starts to disappear until it is all white again. When checked the formatting rules are still present. I checked and didnt see another issue like this…
-
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…