-
Assistance with a formula -- similar to VLookup
I’m not sure if this is possible in Smartsheet but I know the Community will know! For our Annual Meeting, I created a blank sheet that will help us manage our schedule and assigned meeting rooms. Some of the columns are: * Meeting Room Name (the name of the hotel meeting room) * Capacity-Conference (the capacity of the…
-
Items move to the bottom when marked complete
I'm helping my manager set up her "To Do" list and the way that she has been working is that she moves completed items to the bottom of the list, so that what she needs to do is always on top. Is there a way to set up Smart Sheets so that it automatically moves completed items to the end of the list? We know it can be done…
-
Primary column
A new user is wanting me to verify that you cannot reassign the Primary column once your sheet it set up and saved. I'm pretty certain the answer is "no." Blessings, Loann
-
Building Reports for Widgets
In a report, I want to change the column name "sheet name" to "Project" but when I double click on the column the rename option is not available.
-
Google Calendar creating two events for every task
When integrating my Smartsheet into Google Calendar it creates a second event for every task labeled "Edit Smartsheet Rows". I think this has something to do with making it easier to adjust the Smartsheet from the Google Calendar, but I don't need that functionality nearly as much as I need my team's calendars to have the…
-
What’s new?
i get a lot of helpful information from the Community, Help and Blog sites. Is it possible to subscribe to a daily or weekly list of posts to these areas as part of my ongoing education about Smartsheet?
-
Axis scaling for Charts by Smartsheet
I have a standard line graph that my data now exceeds the vertical axis; however, I find no place to adjust the scaling. I the axis from lest to right and it scales, but, now not including 0. It now starts the axis a few values below the lowest value. I switch back to left axis and the chart now starts at 0 again, but, my…
-
Calculating a Date Based on a Future Date
Hello, I am trying to use my smart sheet for a event plan. I have the date of the event at the end of the month, but I'd like the fill in the dates of emails and meetings that will be held before hand. Events Dates 1/25/18 to 1/27/18 Meeting 60 days before Email #1 2 weeks before Email #2 2 days before Any help would be…
-
"Save As New" doesn't retain Auto data...
I use a separate sheet to track projects in each calendar year. This means I need to carry over partially completed projects rows from the previous year's sheet to the next year's sheet. I've used a "Save as New" to duplicate the sheet, formatting and data, but my "Submitted" column which contains the "Date Created" now…
-
New Template(s) for The Public
I want to get this template to smartsheet for the community. Its for a family event with multiple data such as room availability, price, tax deduction, package and room assignment with form. Don't know how to donate this, but I would love to as its great for family get togethers. Won't do another one for 4 years cuzz it…