-
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…
-
Shifting Entire Production Schedule Simultaneously
I want to shift the entire Prodiction Schedule of a project to reflect a new start date. How can I shift all Tasks at onec? Or do I need to each Task individually?
-
Wrapping text
Hi, Is it possible to ensure that wrap text is assigned at all times on a sheet? I seem to be adding lots of detail to numerous rows and I have to constantly select the wrap text icon for each row - it would save time if wrap text could be applied to all rows on a sheet. Thanks Tom
-
Naming a Cell
Can Smartsheet let you "Name" a cell, like in Excel? This would be really useful. You could name certain milestones like "Launch Date" and then automatically calculate the dates of other tasks by subtracting/adding from that. For example, the due date for "Approve Launch Publicity" could be =LaunchDate-14 Today you have to…
