I've tried multiple searches and haven't found the right keyword/tricky phrase to answer my question.
I am using a form for submissions and trying to calculate how long a trend has been occurring. Right now my working formula is this:
Formulas and Functions31Chris Rea
I have a very large worksheet - almost 80 columns wide. Of those, about 20 are formula "Only" columns where personnel will not enter data.
I would love to use the same form, select from the drop down and the fields auto-populate…
We've been hunting high and low for a good task mgmt system for weeks, and Smartsheet is looking very promising. However, there doesn't seem to be any primary or foreign key type functions. How do you relate two sheets with eac…
Formulas and Functions591SeanR
I have noticed there are some confusing limitations imposed on the desktop version of smartsheet that are not on the mobile. I have one primary concern to focus on:
When I am on desktop, card view does not display any more than one line of…
Using Smartsheet30Preston Murphy
It is very inconvenient that I am unable to move rows that have proofing enabled to a new sheet (keeping the proofs intact in the new sheet). We have purchased a new company and we need to move those company-specific rows to a new SmartShe…
We all love a Freebie?
OUR API development team get lots of requests for automation which is the basis of our Smarter Mini Control Center 12 Apps, but one request we have been unable to fulfill so far (unless we use Appsheet with Smartsh…
API & Developers1262Richard Rymill SBP
I understand there is an IOS app but it does not come close to the computer browser based environment, it doesn't perform as well, doesn't have matching capability, heck even the user interface is different. I do not care for the app but…
We currently use a portfolio sheet that tracks our pipeline of clients and organizes them by stages. We love this sheet as it provides us with very useful management level information. However, it does not allows us to manage the "wo…
Premium Apps and Integrations138Jef Forward
Is it possible to reference the latest comment on a row, in a cell?
And if we cannot currently do so, could this be considered an additional feature in the future? I would love to see the latest "update" on a project task as opp…
Is there a way to filter/sort by rows with pending update requests or even mass delete all pending requests?
Pulling together a list of pending requests for follow up as well as deleting all stale pending requests before the next automati…
Formulas and Functions20Dustin Shuman
I am certain this has been asked either currently or in the past, but is the capability to include a formula in the % Allocation column on the product roadmap? Right now, I have a column entitled "% Alloc Calc" next to the "…
Formulas and Functions57Guy Behanna
Hi, Is there any way of doing a cash flow forecast/projection within Smartsheet. With most other project management software this is a built in feature. I would like to do a forecast of the monthly projected cost for the project.
Formulas and Functions42Warren Labuschagne
I know that the smartsheet charts app is still in production, but is it possible to have sheet containing North American states and hyperlinks, then using the 'map' chart, click on a particular state and then it will take you to that hype…
API & Developers286dwayne.waterman21236
Anyone with experience setting up hierarchical numbering schemes?
I want to add a column that is hierarchically auto-numbered such that child rows are added to the numbering scheme as increased decimal points. For example
1. Row 1
Formulas and Functions19Marc Shecter
Using a Dashboard to run our weekly meetings and had an idea to add in a timer inside the dashboard to stay aware of how much time we have left to discuss each topic.
Smartsheet doesn't allow any domain that I know of that can allow…
I have a request to make to Smartsheet Support group, and I am sure a lot of Community users would resonate with me, for this feature!
Adding "mailto: " feature as a feature to dashboard widgets. We know that there are a lo…
I need to attach notes to my line items.
Setting a column as a Note Field is not practical, as I have too much informaiton than can fit on a short line.
Using Comments is not practical, as I need to be able to easily access and edit…
I understand there is no way to link directly to a file from dashboard unless it is in a cloud-based storage program. Has anyone found a workaround? We don't use this kind of storage and I want to be able to link directly to files.
Using Smartsheet780Carly Sorensen
Hey All -
Does this exist yet? See screenshots below. Am i missing a piece in the formula? Or is my column type incorrect? I cant seem to find an article on this. I know its a bit tricky to do this in excel too - and their version doesn't…
Formulas and Functions19Julia Mazza
Dear Smartsheet Team,
PLEASE build desktop apps so that users don't have to rely on their browser to use Smartsheet.
If you look at most people's browser, chances are they have a million tabs opened. That makes it easy for Smartsheet tab…
Using Smartsheet36Christina Wu
I am trying to have a Date Column update with today's date when a single select option is chosen. I don't want to use the system update date column because that will get updated whenever any cell is selected.
For example: I have a single …
Formulas and Functions28Eric Glassey
Is there a plan to include Office documents such as Word Docs or PowerPoints into the functionality of proofing without having to convert them to PDF for uploading them?
Using Smartsheet131Michael Lockwood
I want to be able to validate data in a drop-down menu in one sheet from a column in another sheet.
EX: I have a sheet that serves as a master sheet of projects and the project's properties (Name, budget, etc.), and another sheet that …
Using Smartsheet34Benjamin Hatmaker
Is it possible to create a pdf report based on one form entry? I know I can send an email confirming what has been entered on a form, however I would like to make this a pdf attachment rather than the body of the email.
Using Smartsheet67Improve Consulting
One of the ways, we utilize Smartsheet it is track the publications that come out of research. A few times a year, we are required to report on all publications and they need to be formatted in a specific way. Is there an option to transfo…
Hi I have a requirement to report on the current data for a period and using a Dashboard makes a lot of sense except that since I have to analyse the data every week I need to redo the report each time I want to change
It would be grea…
Using Smartsheet316Brett Holmes
I would like to be able to append/adjust actively sorted values in a range. In other words to be able to handle data more like matrix formulas in excel. Currently this is done with collect, but there isn't a way to change the values being …
Formulas and Functions18[email protected]
Is there a feature that would allow a SmartSheet form to automatically re-open with a new form after hitting submit? we are using a form for each caller and it is cumbersome to hit submit and then find/click the link to open a new form.
Formulas and Functions19Stacey Perry
We have at last now got the ability to as a Description ToolTip call it what you want. Pity it is not picked up automatically as the Default (Editable) Help Tip in the Forms.