-
Smartsheet Update for Attachments
#1 - Strongly DISLIKE #2 - Is there any way to go back to the old attachment format window for rows? The new side bar with multiple clicks to download is super frustrating and is not functional for what we do. Bring back the old attachment window please!!!! What used to be a one-click to download is now several. If there…
-
Attachments update?
Previously in sheets when clicking on the paper clip attachment icon in a row, a popup would appear. Now the attachment panel appears requiring several clicks to download an attachment. Was this a software update or did a setting get changed on my sheet?
-
Auto update cells
I have two columns Status and Closed Date [Status]; data type is lookup (Open, Pending, More Info, Closed) [Data Closed]: data type calendar. Is there a way that I can automatically update the [Date Closed] column with [Status] has been set to "Closed"
-
Approval workflow
Hi Guys, Im new to smartsheet , please help me. I created an approval workflow then if the approver is not around how I am going to reassign it to other approver without breaking the approval sequence. Please let me know your thoughts. Thank you very much.
-
New Attachment Sidebar...
Dislike is my first thing... Can it be moved from the side location? And why does SS never seem to utilize a self closing sidebar??? Frustrating...
-
Form Fields not accepting new values
I created a form for a smartsheet. Within the smartsheet, i have drop down fields for city, state and zip and included the most common values people will need for those fields. I did NOT click the box that states "Restrict to values only" knowing that occasionally there will be an outlier. However, when someone fills in…
-
Automated Update Request Form Changes
I have created an automated workflow, using the Request Update step. This automatically creates the form to send to the user to update. I would like to change the way the form appears and allow multiple line entries. When I go into Forms, that form is not there to update. How do I update the automatically generated form?…
-
highlight today's date
I've just begun using SmartSheet and like it a lot, but it seems as though my team and I keep running into the same problem in various contexts when using Gantt view. Specifically: It's hard to find today's date. Every time we open a sheet, we first need to make sure we KNOW today's date, and then we spend a couple of…
-
AverageIF help
I need help with an AverageIF formula. SmartSheet support gave me this formula for help: =AVERAGEIF([Column6]1:[Column6]22, >0). Essentially, I want the formula to give me the average of the numbers in the Time-to-Fill (Working Days) column BUT ONLY if they list Human Resources in the Department column. I wrote this…
-
Formula Help.
I have a formula going on for the RYG. I added a new column, "Status". I wanted it to be If the status column is FILLED or CANCELLED, the ball will turned Green and canceled out all the other formatting. How can I corporate that into the existing formula below? =IF(TODAY() - [Date Opened]@row <= 60, "Green", IF(AND(TODAY()…