-
Google Sheets Text Indent
When exporting a smartsheet to google sheets, the indent formatting doesn't pass over to the google sheet. All rows that are indented become outdented (left justified). The workaround is to manually edit the google sheet by entering spaces on the lines that were not indented. Does smartsheet have a script or solution to…
-
Smarsheet as a payslip app.
Is it possible? I need to automate my timesheet into a payslip afterwards. Tell me how can I do that? Thanks.
-
add link or iFrame to a workspace
I am fairly new to smartsheets, but would like to know if there is a way to add a button or hyperlink to a workspace (even if i could put a url link off the custom logo) I would like this link to go to a sharepoint site. Ideally it would be the ability to create an iframe. For example inside a workspace i click on new and…
-
Live Data Connector
We're considering upgrading to the Enterprise license so that we can use the Live Data Connector, but before we do, wanted to confirm if you can build reports against "Resource Views" data? From what I've read, can certainly author reports against smartsheets, and I suppose I could reconstitute the data that appears in the…
-
Developing page links via API 2.0
I'm in the process of creating a Master Task List that will incorporate tasks from across multiple sheets so that we may create dependencies across departments. My problem is that I need the Master List to update automatically as the sheets informing it do, but cell linking will not account for new rows added or deleted to…
-
Smartsheet API linkInFromCell
Hi, I am trying to use the Smartsheet API to insert a new row which contains regular cells and 'link cells from another Smartsheet'. Currently, I can only do this in two steps: 1. create new row only with regular cells 2. add 'link cells from another Smartsheet' to this new row API call:…
-
Enterprise video?
Good morning, I did a search in the online videos on demand, but didn't find one. I'm looking for a video that gives a fairly in-depth look at what the Enterprise features are and how this is of greater benefit. Our IT dept is concerned that they would need to be our go-to for help regarding Smartsheet, and I'd like to…
-
Could anyone help me to apply the average formula to a couple cells, which at the same time had an "
Technical Part: I had in cell "[Q1 - Points]2" =IF([1.- Question]2 = "c) Right Answer", "10", "0") and in cell "" I had [Q2 - Points]2=IF([2.- Question]3 = "e) Right Answer", "9", "2") and both formulas work right by themselves. Nonetheless, as I wrote down =AVG([Q1 - Points]2:[Q2 - Points]2) in a new cell, the result was…
-
Exporting to DOMO - columns being read as Text not Number
I currently have smartsheet connector to DOMO to create reports; however, the columns that contain financial data come over as text because smartsheet's column properties are Text/Number. Not Text, Number separately. Anyone know how to make this work? or a workarond? Thanks
-
Deadlines on the Dasboard
We work with dozens of spreadsheets. When will the dashboard allow us to see a snapshot of all upcoming deadlines? Clicking on every spreadsheet is causing usage in the office to significantly decline.
