-
Salesforce Connector - Using "Assigned To" field for automated alert
I have an "Assigned To" column mapping both ways from SS to SF for a services team project estimation process. In Smartsheet, the "Assigned To" field has the employee name and email and automated alerts are sent when someone is assigned. However, when the data pushes from Salesforce to Smartsheet, the "Assigned To" name…
-
Form logic is not working
I submitted to tech support 5 days ago when discovered this and still can't get answers. I have built many many forms in the past however the logic is now not working. I dumped the form and started fresh however still has same issue. Logic is that when customer name is blank only Lot-Unit-Development should show however as…
-
End User - Features locked down?
New to Smart Sheet, been using it for roughly 2 months as an end user. I want to like this app and not sure if it's the app itself or if the PM has locked it down so much that it is unusable. First, I can't sort on a "% Complete" column to know what tasks are complete and which need work on (this is on a filter that the PM…
-
Can a column be formatted for HH:MM entries?
I need like to track working hours in sheets so it would be helpful to format the columns as an hh:mm entry, is this possible? Thanks
-
Access Issues with Smartsheets?
Hi All, I have a paid license on Smartsheets and need to invite free users to certain spaces/documents to collaborate on work documents. However, when I share to users (both free and paid) with admin or editor access, they can't edit the document and have the 'view-only' version. I've tried contacting Smartsheet with no…
-
Can a range be specified with a beginning and no end?
I'd like to create summary rows at the top of my sheet, but specifying the entire column as a range in the formula is causing #circular reference and #block errors. Is there a way to specify a range from row 25 to infinity? I'd like additional rows to automatically be included in my summary calculations. The formulas I'm…
-
Formulas with multiple inputs in smartsheets. Help needed!!
This has been a challenge for me to figure out using the smartsheet platform. I am developing what is essentially a big calculator. The formula that I am trying to implement is: [($26,000 * DTH) + (Risk R * Repair Cost) + (Risk A * repair cost)] * frequency). In this database, each row represents an additional input. The…
-
Is there a way to have Smartsheets automatically sync to a Google Sheet?
Hi, We have need to Automatically sync data from Smartsheet into Googlesheet, please advice, how this can be achieved. is there a way to have Smartsheets automatically sync to a Google Sheet? Please advice. tx Dhananjay Nagarkar
-
Automatic refresh after another person makes change in sheet?
Hello all, It seems that a sheet will automatically refresh after a fixed period of time, assuming you have no unsaved changes, when someone else has made a change to the same sheet. It'll give you a pop-up message and then display the refresh icon next to the sheet title. Does this happen after a specific period of time?…
-
Automate the Progress Bar
Hi there Smartsheet Guru's! Im trying to figure out the best way to automate a progress bar, based of 9 columns that all have check boxes. Screenshot shown:
