-
Web Content Widgets
Is the Web Content Widgets available in the free version of Smartsheet? Which plan do I get this Widgets, Individual, Business, Enterprise ou Premium Options?
-
Update existing smartsheet by excel
Hi, I have a smartsheet with 4 columns： building code, name, cs manager name and supervisor. I create this smartsheet by import excel. Excel has 4 same columns.. However, cs manager always change. We have 1000 buildings. Admin will send update list every week.. I know there is data live connector.. if I change info in…
-
Notifications and update requests
I'm automating the update request and reminder stages to update my activities. The worksheet is not shared, but I've enabled the alert permissions for the least restrictive. The actions and alerts indicator column appears in the reminder symbol and is in pending status, but is not sending email to the requested contact.…
-
Auto Sorting a column By date
I would like to sort my rows by soonest date automatically. I can do it manually but my issue is when other people have a filter on and save it scrambles the whole sort so i have to manually sort everytime to priorities rows. any ideas?
-
Match or VLookup?
I cannot figure out how to cross reference two excel documents for changes made from one day to the next. Long story short, our EDI process is not working at this time. Until it is up & running, our csr is required to manually review each page for changes from the previous day. It is so time consuming but until EDI is up &…
-
INDEX/MATCH not working
Below are two screenshots. The first is a screenshot of my target sheet. The other is a screenshot of my reference sheet. On the reference sheet I have a list along the left. In the column to the right is: =TODAY() On the target sheet is an identical list with the following formula to the right: =IF(TODAY() = INDEX({New…
-
Inserting Barcodes
So - I see the new bar code functionality. However, I don't see information that describes how you would insert a bar code into a sheet (I assume it has to be done so that the search function works). This may be super simple, but I'm a bit lost. 1. What is the best way to generate one? 2. How do you transfer the bar code…
-
Manually Adding to Reports
I'm looking for a way to pull information from other sheets, while also being allowed to manually add data. The reason I'm doing this is to allow for staff to go to one place where we can share individuals goals, tasks and progress. Is there a way to do this? I have tried formulas, but I do not believe it updates when that…
-
CORS in Ionic and third party api(Smartsheet)
I am trying to get data from smartsheet API. When I use postman and nodejs in separate server code, it works. But if I use the API inside the Ionic with HttpClient (@angular/http) it gives CORS issue with run in browser. Failed to load https://api.smartsheet.com/2.0/sheets/1235941564208899972: Response to preflight request…
-
Searching multiple sheets
Is there a way to search multiple sheets when using a filter? Frequently we have multiple properties in the same subdivision and we are looking for a specific lot/block. The filters on our sheets work great we just have to do it multiple times to search all sheets. Just looking for a time saver. Thanks for the help!
