-
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…
-
Moving Massive Qty of Rows
Good Afternoon, I'm currently dealing with a minor issue with SS while moving rows. Once a month, we move a single months worth of data from our main Completed sheet to an Archive sheet I have created, to keep record of previous rows that have been marked complete past 3 months. I do this to keep the loading time down in…
-
Formula & Conditional Formatting Update in Reports
I have several smartsheets that have formulas and conditional formatting. These smartsheets are pulled into a summary report. The formula's and conditonal formatting do not update when opening the report. Each sheet must be opened individually in order for the formula's and conditional formatting to update.
-
Moving rows in Android app
How do I move rows within a sheet on the Android app?