Hi, Our team works with a spreadsheet which currently is updated quite often / simultaneously by several users. We have been facing difficulties whenever new information is added, since sorting is not properly adjusted until we manually select sorting, refresh and save the data. Is there a way to automatically sort…
Until today, we were able to copy a cell from Excel that had a hyperlink, and paste it into a Smartsheet cell and it would maintain the hyperlink. This has stopped working today. It pastes the text, but not the hyperlink, and this is a critical component of our workflow. We use Chrome as our browser and have never had this…
I'd like to select an item from the dropdown menu in my primary column, and have the two following columns fill with predetermined information. Example: We have 100 items. When I select one from the dropdown menu in column 1, the following two columns automatically fill in the prices associated with that item. Can this be…
Hello. I have noticed that charts within a dashboard do not display and throw up a message: "The source data for this chart has changed" when they are pointed at sheets or reports where the value is zero / 0. This is problematic for me since I have created a dashboard for a template set of sheets and reports, and…
I'm having issues where my reports are not updating. Is anyone else having the same problem?
I currently am locked into Outlook 2010 on my PC, but it is connected to Office365. Is there anyway to create a row in a sheet when i flag or categorize an email OR can i forward an email into smartsheet somehow? EDIT: I am open to using Zapier or IFTTT also. Thanks.
Greetings- I'm struggling with the cross-sheet referencing and need some help with a formula. I want to create a new sheet summarizing the values on a corresponding dropdown menu for the name and # of products we sell. I'd like the total number sold for each dropdown choice displayed on the new sheet. In the screenshot,…
We are looking for a Smartsheet freelancer that can help develop additional reports and dashboards. Prefer local to Charlotte NC but open to telecommuting.
Is there a way to hyperlink from one sheet to a specific row in another sheet? I want to be able to click on the link to jump from one sheet row to a specific row in another sheet. Thanks, Stan
Greetings Can someone please explain to me how APIs work ? I am not familiar with many of the technical jargons used on the SMARTSHEET API link. I need to update data on my Gantt charts automaticallu instead of manually inputting the numbers and dates. Can APIs be of any help to carry them out ? Can I somehow read and…