Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Calendar showing 'edit smartsheet rows'
Is there a way to stop the iCal showing 'edit smartsheet rows' on every item? We already have so many shared calendars, this is essentially doubling up on items for no reason...
Calendar view from multiple sheets
HI I am new to Smartsheet and I basically want to use Smartsheet to create a schedule for my business and life to be seen in a calendar and Gantt view. Before creating my sheet/s I am in a dilemma if to create a different sheet for about the seven different projects constituting my business, or to create one sheet. The…
JIRA import duration problem
I'm using the JIRA connector for Smartsheet. I'm attempting to use our "original time estimate" field from JIRA for the "duration" column in Smartsheet. It looks like JIRA sends the time estimate information in minutes, but Smartsheet is treating it as days. So, a task that was given a time estimate of 16 hours in JIRA…
Feature Request: Switch, Vlookup, and/or Lookup Functions
Please add one or more of the following functions: switch, vlookup, and/or lookup. Note that this would make it easier to reference rate categories in a rate table without having to use a huge nested if function.
Organizing/Sorting Workspaces
Hello Fellow Smartsheet Community Members, I am wondering if anyone knows if it possible to sort items in a workspace by the item type. I have a workspace that has a mixture of sheets and reports. Ideally, I would like a way to group all the reports together and all of the sheets together. An anaology is clicking the…
New Lookup Function
New Formulas =lookup() Find the corresponding value of data by row. For example, look up a price of an automotive part by the part number. In this release you will only be able to do lookups on the same sheet as the =lookup() formula. Until this function is usable across sheets, it is basically worthless.
LOOKUP function return value
Hi Smartsheet team, Thanks for getting the much awaited LOOKUP function supported in Smartsheet.. This is a great add !! I see a problem with LOOKUP() return value when the lookup_value is not found in lookup_range. It is returning Empty string instead of an Error. Because of this, I am not able to distinguish between key…
Print and/or Publish without column and row headings?
I know that I can remove row headings when I print, but I can't find an option to remove the column headings. The same options to remove row and column headings are also needed on teh publish feature. SmartSheet provides format opportunities to make a sheet look nice, but then the column headings can really be annoying. Is…
Dynamic Calendar / Calendar View App / Pivot Calendar
I saw a video of the Dynamic Calendar and is impressed with what it can do. Any chance that we can try it out first before paying a subscription for it? Also, can someone advise us the monthly charges if we finally decide to subscribe? I dont seem to be able to find any information about this... Thanks!
Count Down Formula
Does anyone know a formula that can count down days (for example how many days to an election)?
