-
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!
-
Could I refer a cell as part of the sheet name in functions?
I have a column with different carriers such as "AT&T" and "Verizon". And in the following column is a complicated nested functions, and part of it is doing search depending on the carrier name. For example, for the row "AT&T", I want search in the sheet named "ABC AT&T". For "Verizon", I want to search in the sheet named…
-
Help getting Index/Match to find search value (number) in a cell with multiple values (numbers)
I have a sheet with the following formula in a column titled "Status": =IF(ISBLANK([PO#]1), "Processing", IF(INDEX({Status Range}, MATCH([PO#]1, {PO Range}, 0)) = "Loaded", "OTR", IF(INDEX({Status Range}, MATCH([PO#]1, {PO Range}, 0)) = "available load", "Logistics Dept", IF(INDEX({Status Range}, MATCH([PO#]1, {PO Range},…
-
Automatically archive info to new sheet once hit limit .. ?
Hello there, Was hoping someone could have some insight on this. We are looking to see if smartsheets can be the platform for an operators log.. the features of the dashboard and filters to help ease searching ... But our issue is; the size constraints .. we probably would use 5000 lines in a few weeks and to manually…
-
Use a form to lookup sheet data that and add content to it
Hello, I have read the forms with the “VLOOKUP” and “LOOKUP” functions. I am new to smart sheet, but not to excel formulas. I have an associate inspecting carts for wear and tear items, this is working well with check boxes and the photo attachment is awesome to have. Next step is the associate that repairs the cart, I…
-
Linking pages
Hey Guys, i am looking for a way to have vital data show up from one sheet onto another. I am using 6 sheets to keep track of project data. Each individual line in the sheets has all of the data for one project. In this line is a check box that states "Ops Scheduled". I need a way to have projects lines that do not have…
-
Create charts without hidden data
Is it possible to create a chart without including the hidden data?
-
How to use data from another sheet as selection criteria?
Hello, I am trying to build a Report or ANOTHER sheet where I pull data only for Rows from another sheet that have OrderNr=OrderNr from the other sheet. The ordernumbers change daily. I need to be able to refresh automatically on a daily basis. Any recommendations how I should approach this?
-
Enhancement Request: Search Open Sheets
Any improvement is Search is appreciated. Here is another one: Allow Search only Open Sheets Use Case: I have 10 sheets of concern. Search term appears in hundreds of sheets. Since we can't only search a Workspace (and the sheets might be across several anyway), I could open them up to speed up finding what I am looking…
