How to lock/unlock sheet in oder employees could modify it withing the given time frame?
Hello, I would appreciate your help to my question! :) Every month different teams need to input the information in a sheet within a given time frame, after deadline all information is extracted to pdf and shared with the rest of the company. Many often employees are changing information after deadline, which means that…
excel doesn't recognize text/number column from smartsheet
I've linked an Excel worksheet to a Smartsheet report it works fine but one column that has a numbers and text (p.i. 4551A) is imported blank (no data). When is a regular number imports it just fine. Does anybody have any idea what could be the problem? Thanks, Herb
new feature on engage conference:approval request
Hi, I have difficulty to understand new feautre of approval request. I am a property management company and every month need to upload financial report to client web site. Accountant create financial report, then account manager need to approve, after account manager approve, client approval, them mail room will mail…
Update Form Not Working
I have confirmations from two weeks ago that I updated the Smartsheets through an update email that was sent; however, my updates don’t appear. My staff said that the form that pops up on the email that is sent doesn’t work so they have to update changes directly on the sheet. Is anyone else experiencing this?
What workarounds to we have to put an Excel Chart on a sight. I have tried to copy/paste into Paint and save as a picture, then used the Image Widget, however, although the chart is displayed, it is very small and not readable.
Within Alerts & Actions, I know how to send a notification to an Email Address within a specific column of a sheet via the "Contact in column" and selecting the column. That is working great. My question is whether I can send this notification, with a CC to me. I know I can clone the original notification and send it to…
Prevent column name from showing up in Sight
This topic has been discussed before, but, for whatever reason, that discussion is frozen. When using the metric widget in a sight every selected cell will get the name of the column it's in as a passenger. While I can't find any reasons for this approach, it would be nice to have an on/off switch. I know one can remove…
Automatic letter send when drop down field is changed
I would like to set up an automatic "customized" email (letter) to the person who filled out the form (they submit their email into form). I would like this to occur when I change a drop down field in the spreadsheet.
Lookup function in Countifs statement?
In my sheet I have a list of projects with various statuses and I need to do summary numbers by month and reduce the number of statuses to 2 (scheduled and unscheduled). I know how to do this if I use the Lookup function to populate a column with the converted statuses, then use Countifs to get the numbers for each month.…
Sharing With Non-Licensed Users
I have shared many sheets with non-licensed users. They do not have a problem accessing them with the initial email but do not know how to find them later. Are they able to access them if they type the Smartsheet URL into their web search?