-
Sheet to sheet selective data transfer (for new rows)
I currently have two active sheets. The first sheet, we'll call "intake" and the latter "Projects". If I review a *new* row added to "intake" and determine I want to copy it over to "Projects", I need selective data from certain columns on that sheet to transfer to certain columns on "Projects". The columns do not directly…
-
File links uploaded into Google form are garbled in Smartsheet
I have an existing Google form and one of the options is to attach files. When the form is submitted, the values I'm getting in Smartsheet are garbled, something like: "0B6fDccPdKcYeY0tlcjJnVTlMYWM,0B6fDccPdKcYeQi1Malg1YXVDMmM,0B6fDccPdKcYeZkIxVURBU3hjbWc" This column is supposed to be populated with Google Drive links.…
-
Export sheet URLs to excel
Hi, I'm trying to export multiple secure sheet links (urls) to excel (or pull them into a report) so I can upload them to a field in Salesforce. Is there any easy way to do this? Thanks for your help!
-
Is anyone using an Air Pen or scanner to add data to a sheet?
We'd like to enter data from hard copy files into a sheet. We've found air pens or scanners, but we're not sure if we can use them with Smartsheet.
-
Duration Calculation not accurate on my sheet
Duration column on my project includes Hours and Days depending on the task. However, the duration count is inaccurate.
-
How to auto-refresh the datamesh vlookups?
Hi EVeryone- I have a sheet which contains the lookup values to my master sheet, and I have created a few datamesh lookup rules which works well, but if a new row gets added to my master sheet, I need to go to datamesh website and refresh the rules my self. Is there anyway I can automate this so everytime I dont have to go…
-
new feature on engage conference:approval request
Hi, I have difficulty to understand new feautre of approval request. I am a property management company and every month need to upload financial report to client web site. Accountant create financial report, then account manager need to approve, after account manager approve, client approval, them mail room will mail…
-
Lookup function in Countifs statement?
In my sheet I have a list of projects with various statuses and I need to do summary numbers by month and reduce the number of statuses to 2 (scheduled and unscheduled). I know how to do this if I use the Lookup function to populate a column with the converted statuses, then use Countifs to get the numbers for each month.…
-
Split-screen View to compare sheets
In other programs there is a split-screen view or arrange windows in order to compare two documents. Other than opening two different Smartsheet windows (and, subsequently, opening a different sheet in each window), is there a way to compare sheets? I have two versions of a sheet (where I am using data from one to update…
-
Send Row Default Fields
Greetings, Will there ever be an option to save the "Send" (by row) "Include" options to be reused. I found a work-around to create a report with only the pertinent fields, but this is unwieldy. Example: When I have a support ticket to answer, I do not want all of the fields to display in the email and going through and…
