-
Help with Sites and Sheets
I'm struggling to create two things in my Smartsheet. I'd like to have a countdown in the completation date from "today" until our project's expected final day. And capturing the %done of the project in smartsheet, maybe I'm doing something wrong but the =AVG() is not working for me. I'd like the program health to indicate…
-
Auto-increment a new form entry if it matches an existing name
My team is using Smartsheet to track interactions with our customers on Facebook. To keep a record of the interactions, we're using a form to populate a sheet with the data (time, date, sentiment, that sort of thing). I'd like to find a way to automate one of the questions in the form - how many times we've interacted with…
-
Hierarchy from Excel
Hi all, I have an Excel sheet that I export from TFS and has a hierarchy defined. I would like to copy it into Smartsheet and maintain that hierarchy without having to manually recreate it. Can this be done? I am not opposed to using Excel to reformat appropriately. I am just trying to avoid recreating the hierarchy every…
-
Dependencies, critical path and changing dates
Hi everyone, I have some issues with the dependencies function in Smartsheet and was wondering whether someone could help out. I am really keen to see the dependencies and the critical path, which are possible in SmartSheets. However, I found two issues... * 1. I would like to be able to see, that if I want to change a…
-
Ordering Search Results
Is there a way to order search results from the Current Sheet by their line number within the sheet?
-
What network ports are used for uploading file attachments in Smartsheet
I want to be able to block the network ports in my firewall to prevent a user from being able to attach a file to smartsheet. If not ports, then what is it connecting to on the other side and I can block that. I have the Team plan, and unlike the Enterprise plan, does not give me the control to restrict/block that…
-
Error in creating new Smartsheet from Google Drive
Anyone see this or know how to get around this? I could not find anything related to this problem. I have successfully installed the Smartsheet app to Chrome from the Chrome Web Store. I do New->More->Smartsheet. I get past the "Your domain administrator has approved access to Smartsheet" . Then, I see the error message,…
-
Email Notifications and Lost Data
No one in our company is receiving email notifications from SmartSheet. This started happening after the upgrade they did over the weekend. We have also lost some data from our sheets. The data was entered and then later disappeared. I've tried emailing SmartSheet about the issue, but have not received and explanation. I'm…
-
Enhancement Request: Batch Updating in App
Hello - It would be great if a user can update multiple columns (status, dates, etc.) by being able select two or more rows and selecting a "batch update" button to update all of the selected rows at once. Currently, user has to select the column to change, then update a particular field, then repeat if multiple fields…
-
Modify the styles of the web form iframe
Hi there! I am wondering if is an opcion to modify the styles of the web form iframe? Right now I am using the free version, but being a member/licensed user and paying every month is there an option to modify the styles of the iframe? We are a company and we would like to integrate the form on our website, but we need to…