-
How can I restore rows after moving it to another sheet?
Dear all, I moved some rows to another sheet but now I could not restore it. Please help me to clarify it. Thank you. Best Regards, Phuong Truong
-
Embed PDF files in dashboards?
Is there really no way to embed PDF files into SmartSheet dashboards? I can do this in SharePoint and Confluence so I figured it would probably be available in SmartSheet. If this is not possible, does anyone have a work around? I realize I can take a snapshot of the PDF and save it as an image and use the image Widget,…
-
How can I specify a range in one column and return a value in another column?
I want something like this (that works:-)) =IF([Estimated Days to Completion]<10, "Red", IF [Estimated Days to Completion]>10, "Green") So, if I specify a value less than 10 in one column, a red dot appears in the other column. Same idea for green. Thanks.
-
Do daily update requests get sent out during non-workdays?
We have an update request that will ask foremen to update the percent of a job they have done. The update request is set to trigger daily by using the date trigger option in the automation menu. Would these requests be sent out during non-workdays?
-
Workspace - Is that Possible to share with Non Users?
Dear All, Currently. we are able to share spreadsheet with Non Users, when we make the file as "public", then, no one needs a password, our team, can just access the file. Now, we are trying to do the same with a workspace, but we could not found anything like that. Do you know if this is possible? Thank you so much for…
-
Can I customize the Confirmation emails from the Approvals Workflows?
Hi, I have an approval workflow set up and I have multiple stages to it. When the approver submits their approve or decline the confirmation email they get has all of the smartsheet fields smashed together horizontally in the email. Is there a way to either customize this email so that only certain fields display or no…
-
Is there a way to automatically copy filtered content from sheet A to sheet B daily?
I have a sheet (sheet A) that is my source sheet, and the content is updated frequently. I'd like to filter sheet A on a particular column, and copy the filtered content to another sheet (sheet B) to share with my users, automatically at a daily basis. Before copy, content in sheet B needs to be cleared. I tried to use the…
-
Calendar in Smartsheet - selecting a date many years ago
Hello, I'm setting up a form for my colleagues using Smartsheet, and have included a date field using the "Calendar" option. In most cases, the date they select will be anywhere from the 1980s to 2015. The calendar option defaults to the current date, and as far as I can tell, there isn't an option to select a year, then…
-
Automating Status Balls Around Date & Checkboxes
Hey All, I would like to to automate the g/y/r status balls around both due date and checkboxes. I would like the status ball to display green if the "due date" is further out than a week from present day. I would like the ball to show yellow if the "due date" is within one week of today. And I would like it to display…
-
Trying to insert and not type-over
When I double-click a cell to add text to a cell, I can add additional text after the entry, but I cannot insert text in the middle of an entry, as it will overwrite any text thereafter. It just started happening yesterday. I think I was typing to fast and pressed a button(s) that activated this function and now I have no…
